Mega Code Archive

 

Categories / MySQL Tutorial / Select Query

 

As

Defining a new structural element (table or column) by aliasing an existing value. A common use for this is to create a shorthand reference to elements with long names to make the SQL statements shorter. SELECT <columns> FROM <existing_table_name> AS <new_table_name> is simply a reference that exists for the duration of the SQL statement. SELECT t1.first_name FROM employee AS t1;