/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 vote138 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote148 views1 answer
Sqlalchemy query return only n results
SQL
0 vote120 views1 answer
Create synonym for dblink in oracle
SQL
0 vote131 views2 answers
Mysql dump structure only
SQL
0 vote124 views1 answer
Oracle procedure teamplate
SQL
0 vote116 views1 answer
Char varchar nvarchar sql
SQL
2 votes112 views1 answer
Set username and password for postgresql database
SQL
12 votes110 views4 answers
Mysql get date difference in hours
SQL
0 vote114 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote112 views1 answer
Luu ckeditor vao mysql
SQL

Share