/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 vote194 views1 answer
Drop CHECK constraint sql
SQL
0 vote143 views1 answer
How to get last client id sql
SQL
10 votes183 views1 answer
Create table oracle
SQL
6 votes182 views4 answers
Delete table sqlite
SQL
2 votes181 views1 answer
Mysql sysdate
SQL
0 vote197 views1 answer
Declare or use variable in snowflake
SQL
0 vote187 views1 answer
Oracle last character of string
SQL
2 votes199 views1 answer
How to get weekday from old date in sql
SQL
3 votes181 views1 answer
Oracle revoke grant
SQL
0 vote176 views1 answer
Oracle list chain steps
SQL

Share