/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

2 votes388 views1 answer
Oracle find constraints referencing a table
SQL
0 vote337 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote336 views1 answer
Mysql root localhost run
SQL
0 vote327 views1 answer
Mysql add comment to column
SQL
5 votes334 views1 answer
Find table from column name in sql
SQL
1 vote327 views1 answer
Sql avg group by
SQL
0 vote355 views1 answer
Count number of entires by months sql
SQL
0 vote360 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote357 views1 answer
Show mysql account privilleges
SQL
0 vote335 views1 answer
Alter table name including schema
SQL