Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to print out column name differently 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 :: sql online compiler 
Sql :: sql update subtract value 
Sql :: update database collation in postgresql 
Sql :: mysql current date between two dates 
Sql :: joining tables in sql 
Sql :: sorting desc in sql 
Sql :: equi join in sql 
Sql :: error code 1241 mysql 
Sql :: python list from sql 
Sql :: create procedure sql 
Sql :: inner join vs outer join 
Sql :: ms sql select datetime as date 
Sql :: table user postgres 
Sql :: how to link java and mysql 
Sql :: sqlite3.OperationalError: near "WHERE": syntax error 
Sql :: constraint sql 
Sql :: sql select condition with left join 
Sql :: SQL Comments With Statements 
Sql :: sql server set complex constraints 
Sql :: how to set up an anonymous function to variable in swift 
Sql :: Column count of mysql.user is wrong. Expected 42, found 44. The table is probably corrupted 
Sql :: Oracle Function execution 
Sql :: what does the -p flag do in mysql cli 
Sql :: narural join 
Sql :: learnxinyminutes sql 
Sql :: Original Query 
Sql :: postgres another version 
Sql :: postgres row expiration 
Sql :: error infor in sql server 
Sql :: sql server split string and insert into table select 
ADD CONTENT
Topic
Content
Source link
Name
8+2 =