/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 vote419 views1 answer
Sql show founctions
SQL
0 vote359 views1 answer
Hive batch drop table
SQL
0 vote356 views1 answer
Import big data to mysql
SQL
0 vote342 views1 answer
Sqlserver now
SQL
1 vote350 views1 answer
Psql connect to another database
SQL
13 votes403 views2 answers
Oracle select into and inner join
SQL
1 vote380 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote376 views1 answer
Consulta alias con inner join
SQL
0 vote412 views1 answer
New rails app with mysql
SQL
0 vote358 views1 answer
Trigger stock phpmyadmin output message
SQL

Share