/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

6 votes344 views2 answers
Oracle
SQL
0 vote354 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote319 views2 answers
Avg() sql
SQL
0 vote337 views1 answer
Postgres declare variable
SQL
0 vote392 views1 answer
Update top 100 order by sql server
SQL
11 votes364 views3 answers
Sql line numbers
SQL
0 vote323 views1 answer
Default column value in sql same as other column
SQL
6 votes439 views2 answers
Install psql mac
SQL
0 vote353 views1 answer
Mysql select smaller of two values
SQL
-2 votes355 views1 answer
No module named '_sqlite3
SQL

Share