/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

1 vote195 views3 answers
How to reset id column in sql server
SQL
0 vote228 views1 answer
Postgres - Login and connect as default user
SQL
1 vote224 views1 answer
Postgresql update auto_increment value
SQL
9 votes218 views3 answers
Date format in sql
SQL
8 votes183 views3 answers
Connect python to mysql
SQL
0 vote187 views1 answer
How to check even or odd in sql
SQL
18 votes187 views6 answers
Drop table if exists
SQL
0 vote257 views1 answer
Connect google bigquery connect using sqirrel
SQL
6 votes170 views1 answer
Rank function in oracle with example
SQL
1 vote234 views1 answer
Sql in array query
SQL

Share