/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

3 votes338 views1 answer
Show index table
SQL
0 vote346 views1 answer
Login phpmyadmin without password
SQL
7 votes385 views1 answer
Mysql remote connection command line
SQL
0 vote345 views1 answer
Soql user profile
SQL
2 votes395 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
0 vote351 views2 answers
Postgres another version
SQL
0 vote320 views1 answer
Postgres get running query
SQL
12 votes362 views2 answers
Find duplicates mysql column
SQL
0 vote347 views1 answer
Mysqldump don't drop table
SQL
4 votes340 views1 answer
Oracle error compilation line
SQL

Share