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");
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 |