/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 vote280 views1 answer
Alphabetical order mysql
SQL
15 votes277 views3 answers
Find duplicate keys in mysql
SQL
3 votes276 views3 answers
Docker create postgresql database
SQL
0 vote289 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
2 votes292 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote290 views1 answer
Postgres row expiration
SQL
0 vote294 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
3 votes268 views2 answers
Oracle apex charging debug
SQL
15 votes268 views4 answers
Pl sql
SQL
22 votes276 views4 answers
Mysql date format
SQL

Share