Simplest concatenate string: space : String Append « String « SQL / MySQL






Simplest concatenate string: space

/*
mysql> select CONCAT("a"," ","B");
+---------------------+
| CONCAT("a"," ","B") |
+---------------------+
| a B                 |
+---------------------+
1 row in set (0.00 sec)


*/  
select CONCAT("a"," ","B");
           
       








Related examples in the same category

1.Concatenate string with NULL value
2.Simplest concatenate string 2
3.Append string in select clause
4.Concatenating String Values: Joining Strings
5.String function: concat