/SQL/How to output a different column name in mysql

How to output a different column name in mysql

-- MySQL

SELECT column1 AS name1, column2 AS name2
FROM table1;

-- AS allows your to replace the name of a column when outputting but does not
-- actually change the column name within the database.

Similar codes

4 votes193 views1 answer
Oracle show error line number
SQL
-1 vote189 views3 answers
Error mysql shutdown unexpectedly
SQL
3 votes192 views2 answers
Mysql time
SQL
0 vote215 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
10 votes178 views2 answers
Linux command line import mysql database
SQL
0 vote202 views1 answer
Excel export from sql using python
SQL
0 vote218 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
4 votes193 views1 answer
Wilayah indonesia database
SQL
2 votes180 views1 answer
Can you use a where clause for a child query
SQL
0 vote209 views1 answer
Mysql range of dates overlap
SQL