/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

10 votes107 views1 answer
Query to find object dependencies in oracle
SQL
2 votes105 views2 answers
Mysql all columns
SQL
5 votes96 views1 answer
How to check port number for postgresql
SQL
0 vote106 views1 answer
On update current_timestamp jpa
SQL
1 vote112 views1 answer
Postgres get timestamp
SQL
-1 vote57 views3 answers
Ubuntu install mssql
SQL
1 vote107 views1 answer
Loading local data is disabled mysql
SQL
0 vote127 views1 answer
Pgadmin check database
SQL
0 vote108 views1 answer
Mysql default uuid
SQL
0 vote126 views2 answers
Collation in sql
SQL

Share