Insert INTO CUSTOMERS VALUES(5, 'Hardik', 27, 'Bhopal', 8500.00) Insert INTO CUSTOMERS VALUES(4, 'Chaitali', 25, 'Mumbai', 6500.00) Insert INTO CUSTOMERS VALUES(3, 'kaushik', 23, 'Kota', 2000.00) Insert INTO CUSTOMERS VALUES(2, 'Khilan', 25, 'Delhi', 1500.00) Insert INTO CUSTOMERS VALUES(1, 'Ramesh', 32, 'Ahmedabad', 2000.00) The basic syntax of a table alias is as follows.Īssume we have created a table with name CUSTOMERS in SQL database using CREATE TABLE statement as shown below −įollowing query inserts values into this table using the INSERT statement −

Aliasing Table NamesĪliases are used to address database tables with a shorter or more meaningful name within an SQL query. By assigning temporary names to these tables or columns, you can make your SQL query more readable and easier to understand. Aliases are created with the AS keyword.Īliases can be especially useful when working with complex queries involving multiple tables or columns with similar names. The use of aliases is to address a specific table or a column in an SQL statement without changing their original name in the database. You can rename a table or a column in a database temporarily by giving them another pseudo name.

Mysql union with alias column names