/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

1 vote339 views1 answer
Ora-01950 no privileges on tablespace
SQL
11 votes338 views1 answer
Sql query to find duplicates in column
SQL
0 vote288 views1 answer
How to set field to null in sql
SQL
0 vote338 views4 answers
Mysql on kubernetes
SQL
5 votes324 views1 answer
Oracle columns in all_tables
SQL
-1 vote320 views2 answers
On update cascade
SQL
0 vote374 views1 answer
Sql server synonym
SQL
0 vote392 views1 answer
Get initial in sql
SQL
0 vote518 views1 answer
Sql change a colum to unique
SQL
0 vote323 views1 answer
Como hacer un select entre fechas mysql
SQL