/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 vote203 views1 answer
Bitmap join index
SQL
0 vote197 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote216 views2 answers
Starts and end with vowel sql
SQL
0 vote189 views1 answer
Database springboot
SQL
0 vote194 views1 answer
How to make case insensitive in sql
SQL
0 vote214 views1 answer
View to table sql
SQL
1 vote222 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
-1 vote195 views3 answers
Error mysql shutdown unexpectedly
SQL
0 vote162 views1 answer
Raven ql select count
SQL
0 vote211 views1 answer
Grant owner postgresql
SQL

Share