/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 vote224 views1 answer
Varchar2 length in oracle
SQL
0 vote164 views1 answer
Grant privileges of databse to user
SQL
0 vote180 views1 answer
Sql select column name like from multiple tables
SQL
0 vote197 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote157 views1 answer
Postgresql newline character
SQL
1 vote240 views1 answer
Mysql connect command
SQL
10 votes160 views5 answers
Mysql create user
SQL
0 vote209 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote174 views1 answer
How get data from database if id not found then search another column
SQL
0 vote255 views1 answer
Install ms sql server management studio
SQL

Share