Mysql - Set alias name for a field, Temporary Files name

Set alias name for a field

How to set alias for a field temporarily?
Mysql AS Clause a simple example

alias is a short name used in mysql to shorten the query. it is used with "AS" in mysql query.

For eg:

 SELECT SUM(*) AS cnt from test

you can also use it in multiple table select query.

 SELECT a.cId, b.id FROM test AS a, user AS b WHERE a.cId=b.id 

The topic on Mysql - Set alias name for a field is posted by - Math

Hope you have enjoyed, Mysql - Set alias name for a fieldThanks for your time