Syntax error What MySQL returns if the argument of QUOTE() function is NULL?

What MySQL returns if the argument of QUOTE() function is NULL?

MySQL returns NULL if the argument of QUOTE() function is 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)
Updated on: 2020-02-07T07:15:41+05:30

141 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements