/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 vote118 views1 answer
Sqlite update from another table
SQL
0 vote120 views1 answer
Sql server information_schema temp tables
SQL
0 vote120 views1 answer
Search In the Database using Text
SQL
6 votes126 views3 answers
Date_trunc postgres
SQL
0 vote122 views1 answer
Delete a record from a table sqlite3
SQL
0 vote129 views4 answers
User defined function sql
SQL
3 votes140 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote112 views2 answers
Mysql to python pandas
SQL
6 votes131 views2 answers
Oracle trigger
SQL
0 vote117 views1 answer
Sql recherche nom prenom
SQL

Share