SELECT with Alias AS
suggest changeSQL 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)
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents