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;
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;