/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

1 vote257 views2 answers
Oracle create synonym
SQL
8 votes256 views6 answers
Sql insert
SQL
0 vote290 views1 answer
How to rename a database in tsql
SQL
0 vote248 views1 answer
Duplix print in Smartforms
SQL
2 votes267 views1 answer
How to select from mssql
SQL
0 vote258 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote267 views1 answer
Local pg_sql to heroku pg_sql
SQL
3 votes237 views3 answers
Into in sql
SQL
0 vote271 views1 answer
Python mysql check if database exists
SQL
0 vote224 views1 answer
T-sql conditional order by multiple columns
SQL

Share