When you retrieve a result set, MySQL gives every output column a name. (That’s how
the mysql program gets the names you see displayed in the initial row of column headers
in result set output.) By default, MySQL assigns the column names specified in theCREATE TABLE or ALTER TABLE statement to output columns, but if these defaults are not
suitable, you can use column aliases to specify your own names.