Concatenate string with NULL value : String Append « String « SQL / MySQL






  1. SQL / MySQL
  2. String
  3. String Append

Concatenate string with NULL value

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


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








Related examples in the same category

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