/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 vote293 views1 answer
How to install postgresql on wsl
SQL
6 votes279 views2 answers
Find mysql version linux
SQL
0 vote254 views1 answer
Strat with in sql
SQL
0 vote264 views1 answer
Flask sqlalchemy decimal
SQL
0 vote280 views1 answer
Python sqlalchemy orm to select null values
SQL
1 vote270 views1 answer
Postgres start database on linux
SQL
2 votes291 views1 answer
Mysql increment value by 1 in update
SQL
0 vote265 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote328 views1 answer
Drop view sql
SQL
0 vote265 views2 answers
How to start postgresql laravel
SQL

Share