/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 vote206 views2 answers
Sql where is not number
SQL
0 vote208 views1 answer
Compression of dabatase mysqldumo
SQL
103 votes336 views1 answer
Like sql
SQL
1 vote194 views1 answer
Set statiscis on in sql server
SQL
0 vote205 views1 answer
Postgresql create user roles
SQL
0 vote194 views1 answer
Join in update query in mysql
SQL
0 vote167 views1 answer
Create duplicate table in postgresql
SQL
0 vote203 views1 answer
Sqlcmd no headers
SQL
3 votes201 views4 answers
Order by desc postgres
SQL
0 vote248 views1 answer
Insert into using contant values and source table columns with sql
SQL

Share