mysql aliasing a table and referring to a table using alias code example

Example 1: alias mysql

SELECT sysdate() AS "Current date";   -- MySql Alias

Example 2: alias mysql

SELECT coluna
AS alias_coluna
FROM tabela AS alias_tabela;