how to output a different column name in mysql

Solutions on MaxInterview for how to output a different column name in mysql by the best coders in the world

showing results for - "how to output a different column name in mysql"

1-- MySQL
2
3SELECT column1 AS name1, column2 AS name2
4FROM table1;
5
6-- AS allows your to replace the name of a column when outputting but does not
7-- actually change the column name within the database.

similar questions

change column name mysql mysql show column data types how to alter table column name in mysql list in one column mysql how ot change name of column mysql mysql select columns as string mysql get column names from table mysql get only the field names in a table get table which have specific columns in mysql change column name in mysql modify column name in mysql mysql set column equal to another automatic mysql select all columns and specific fields as change column name mysql command line mysql table column name with special characters select from column mysql mysql to get column name in database set column in all row mysql mysql calculated column mysql query to get column names mysql select all table that have field names get the mysql table columns data type mysql show table columns mysql command line mysql all columns mysql where derived column

queries leading to this page

how to select column name in mysql how to get table column names mysql mysql query column where name is not mysql list table column names how to print a different column name in mysql how to table column name in mysql get column names of table mysql mysql print column names get table columns names with result in mysql mysqli ouput field name how to get the column name from table in mysql php select column names from table mysql mysql select field name from quety how to get database table header name in mysql mysql select column names from table get columns name mysql table mysql output column names name my own column in mysql how to output a different column name in mysql how to get list of fields in a table in mysql mysql get column name without using information schema mysql get field names from tables how to output a different column name in mysql