/SQL/Mysql concatenate two columns into one

Mysql concatenate two columns into one

Mysql concatenate columns

SELECT CONCAT(first_name, ' ', last_name) AS 'Name', dept FROM users;

4

Source: gist.github.com

Mysql concatenate two columns into one

SELECT concat(first_column, ' ', second_column) from table_name

2

Similar codes

0 vote229 views1 answer
Psql generate id in existing database
SQL
1 vote197 views3 answers
Union in sql
SQL
3 votes232 views1 answer
Oracle cannot access v$session
SQL
1 vote203 views1 answer
Mysql get domain from url
SQL
0 vote275 views3 answers
Characters found after end of sql statement
SQL
0 vote221 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote213 views1 answer
MySql Modify Increment
SQL
-1 vote293 views3 answers
PS5
SQL
1 vote203 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote214 views1 answer
Postgresql in vs any performance
SQL

Share