/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 vote146 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote135 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote165 views1 answer
Sql log file inof
SQL
1 vote147 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote150 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
3 votes145 views1 answer
Show index table
SQL
0 vote146 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote207 views1 answer
Generate sql from specific migration ef core
SQL
1 vote150 views1 answer
Mysql size int
SQL
0 vote172 views1 answer
Connect laravel to mysql on mac
SQL

Share