Use alias : Alias « Select Clause « SQL / MySQL






  1. SQL / MySQL
  2. Select Clause
  3. Alias

Use alias 

  
/*mysql> select 'Manish Sharma' as Name;
+---------------+
| Name          |
+---------------+
| Manish Sharma |
+---------------+
1 row in set (0.00 sec)

*/
select 'Manish Sharma' as Name;








Related examples in the same category

1.Use SUM and alias
2.Use AVG and alias
3.Using Aliases
4.Select calculated value with alias
5.Provide an alias to make a heading more concise or meaningful
6.Alias for calculated value