use alias as a variable mysql 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;
SELECT sysdate() AS "Current date"; -- MySql Alias
SELECT coluna
AS alias_coluna
FROM tabela AS alias_tabela;