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)
Related Articles
- What MySQL returns if the first argument of INTERVAL() function is NULL?
- What MySQL returns if the list of strings, provided as argument in FIELD() function, are NULL?
- What MySQL returns if we use UNIX_TIMESTAMP() function with no argument?
- What MySQL returns if the search string, provided in FIELD() function, is NULL?
- What happens if a NULL argument is provided in MySQL CONV() function?
- What MySQL TRIM() function returns if 1st argument(i.e. BOTH, LEADING, TRAILING) is not specified?
- What MySQL returns if we use NULL, as both the arguments, as one of the argument and as a separator, in CONCAT_WS() function?
- What MySQL ASCII() function returns if I will provide NULL to it?
- When MySQL IN() function returns NULL?
- What MySQL MAKE_SET() function returns if there are all NULL at the place of strings?
- What MySQL COALESCE() function returns if all the arguments provided to it are NULL?
- What MySQL returns if we provide value larger than 255 as argument to MySQL CHAR() function?
- What happens if we provide NULL as an argument to MySQL CHAR() function?
- What MySQL returns if the search string is not in the list of strings provided as argument in FIELD() function?
- What MySQL ELT() function returns if the index number, provided as an argument, is higher than the number of strings?
Kickstart Your Career
Get certified by completing the course
Get Started