SELECT with Alias AS

suggest change

SQL aliases are used to temporarily rename a table or a column. They are generally used to improve readability.

Query

SELECT username AS val FROM stack; 
SELECT username val FROM stack;

(Note: AS is syntactically optional.)

Result

+-------+
| val   |
+-------+
| admin |
| stack |
+-------+
2 rows in set (0.00 sec)

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:



Table Of Contents