/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 vote208 views1 answer
Query to insert image
SQL
0 vote216 views1 answer
How to open mysql in docker
SQL
0 vote244 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
5 votes239 views1 answer
Oracle add time to date
SQL
0 vote198 views1 answer
How to get n result in sql
SQL
0 vote240 views1 answer
Oracle winter time change
SQL
3 votes216 views1 answer
How to check schema privileges in oracle
SQL
1 vote208 views1 answer
Oracle index partition
SQL
1 vote232 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
13 votes215 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL

Share