What will MySQL return if the argument to the QUOTE() function is NULL?

If the parameter of the QUOTE() function is NULL, MySQL will return NULL.

Example

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)

The above is the detailed content of What will MySQL return if the argument to the QUOTE() function is NULL?. For more information, please follow other related articles on the PHP Chinese website!