Q. What is a table alias? What is the purpose of table alias?
Answer: -
Table Alias:-
A Table Alias is a temporary label given along with table name in FROM clause.
• The purpose of table alias is To cut down on the amount of typing required in your queries you can use aliases for table names in the SELECT and WHERE clauses.
For example:- if you wanted to use the abbreviation 'T' for the 'table' in your query all you need to is tell MySQL that 'table' will be referenced by 'T' in the FROM clause.
A Table Alias is a temporary label given along with table name in FROM clause.
• The purpose of table alias is To cut down on the amount of typing required in your queries you can use aliases for table names in the SELECT and WHERE clauses.
For example:- if you wanted to use the abbreviation 'T' for the 'table' in your query all you need to is tell MySQL that 'table' will be referenced by 'T' in the FROM clause.
Post a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )