MySQL: Giving column as alias name

This entry is part 13 of 26 in the series Learn MySQL

At times, especially for generating reports, we might want to give a different column name or an alias to a table.

For example, in our example, we can use the following statement to change the artiste column to name.

select artiste as Name, album, price from artist

column_name

Another simple example is:

select now() as Date;

column_name1

 

 

 

Series Navigation<< MySQL: Handling empty string
MySQL: Show databases and show tables >>