As : AS « Select Query « MySQL Tutorial






  1. MySQL Tutorial
  2. Select Query
  3. 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;








2.11.AS
2.11.1.As
2.11.2.Use As in table joins
2.11.3.Practical Uses of As
2.11.4.Aliasing Function output
2.11.5.Use AS to give a more meaningful name