MySQL: Aliases

Aliases make writing queries easier when dealing with multiple tables. It even makes it easier when accessing queries from scripting languages (e.g. PHP).

Below is an example:

SELECT tb.column1 AS col1, tb.column2 AS col2
FROM mytable AS tb;