Sql

Search

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.

Comment

PREVIOUS	NEXT

Code Example
Sql :: join with multiple conditions sql
Sql :: sql delete dastabase
Sql :: sql not
Sql :: ignore duplicate rows in sqlite
Sql :: create a table
Sql :: how to add multiple column in mysql
Sql :: json object to column value in sql server
Sql :: desc sql
Sql :: doctors appointment
Sql :: what is common table expression in sql
Sql :: mysqlimport
Sql :: mac mysql this is incompatible with sql_mode=only_full_group_by
Sql :: sqlite csv
Sql :: sql and or
Sql :: mysql view
Sql :: convert sql to linq c# online
Sql :: mov volume before build
Sql :: sql online code
Sql :: knex last insert id mysql
Sql :: mysql coonect sample code
Sql :: mssql + bit + in python orm
Sql :: HOW to select specific table data from an mysql databse server:
Sql :: influxdb clone measurement
Sql :: postgresql Change role for the current session to the new_role
Sql :: convert sql to linq online converter
Sql :: Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
Sql :: sql varchar(255)
Sql :: sql server select query datatype
Sql :: setval postgres example table id
Sql :: select count(*) from table

Search

SQL

how to output a different column name in mysql

ADD CONTENT