如果QUOTE()函数的参数为NULL,MySQL将返回什么?
如果QUOTE()
函数的参数为NULL,则MySQL返回NULL。
示例
mysql> Select QUOTE(NULL); +-------------+ | QUOTE(NULL) | +-------------+ | NULL +-------------+ 1 row in set (0.00 sec) mysql> Select Name, QUOTE(NULL) from student where id = 1; +--------+-------------+ | Name | QUOTE(NULL) | +--------+-------------+ | Gaurav | NULL | +--------+-------------+ 1 row in set (0.08 sec)