MySQL Append


 

MySQL Append

This example illustrates how to append the value of two column.

This example illustrates how to append the value of two column.

MySQL Append

This example illustrates how to append the value of two column.

In this example we use the 'CONCAT' function to append the two values of two column.

 

Query

 

SELECT CONCAT(first_name, " ", last_name) 
from roseindia where city = 'lucknow';

 

Output

 

+------------------------------------+
| CONCAT(first_name, " ", last_name) |
+------------------------------------+
| sandeep suman                      |
| amit raghuvansi                    |
| amar patel                         |
+------------------------------------+

 

 

Ads