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


Another simple example is:

select now() as Date;





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

Leave a comment

Leave a Reply