INSERT INTO employee (Id, `Name`, Department, Salary, Gender, Age, City) VALUES (1004, 'Mike Walker', 'Finance', 50000, 'Male', 28, 'London') INSERT INTO employee (Id, `Name`, Department, Salary, Gender, Age, City) VALUES (1003, 'James Brown', 'Finance', 50000, 'Male', 28, 'Delhi') INSERT INTO employee (Id, `Name`, Department, Salary, Gender, Age, City) VALUES (1002, 'Mary Smith', 'HR', 45000, 'Female', 27, 'Mumbai') INSERT INTO employee (Id, `Name`, Department, Salary, Gender, Age, City) VALUES (1001, 'John Doe', 'IT', 35000, 'Male', 25, 'London') Please use the following SQL Script to create the company database and employee table with the required records. We are going to use the following Employee table to understand Aliases in MySQL with Examples. The AS keyword is used to define the Alias in SQL statement. Also, if the table names or column names are big or not readable. The Aliases are more useful when multiple columns or multiple tables are used in a single query. The purpose of Aliases is to make table or column names more readable. In MySQL, an Alias means a temporary name given to a table or a column. Please read our previous article where we discussed the LIMIT Clause in MySQL with Examples. In this article, I am going to discuss Alias in MySQL with Examples. Data Structures and Algorithms Tutorialsīack to: MySQL Tutorials for Beginners and Professionals Alias in MySQL with Examples.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |