/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 vote191 views1 answer
Disable database droping sql
SQL
1 vote176 views1 answer
Create procedure with encryption
SQL
-1 vote251 views3 answers
PS5
SQL
1 vote182 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote143 views4 answers
Sql limit 1 offset 1
SQL
0 vote164 views1 answer
Duplicate foreign key constraint name
SQL
0 vote189 views1 answer
Kill slow queries mysql
SQL
0 vote185 views1 answer
Windows aggregate functions in postgresql
SQL
0 vote198 views1 answer
Oracle concat datetime
SQL
0 vote201 views1 answer
Check if mysql db is used
SQL

Share