Mega Code Archive

 

Categories / MySQL / Data Type

 

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