- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What MySQL EXPORT_SET() function returns if any of the argument is NULL?
MySQL EXPORT_SET() function would return NULL if any of the argument provided in it is NULL. Following examples would demonstrate it −
Example
mysql> Select EXPORT_SET(NULL, 'Y','N',',', 4); +----------------------------------+ | EXPORT_SET(NULL, 'Y','N',',', 4) | +----------------------------------+ | NULL | +----------------------------------+ 1 row in set (0.00 sec) mysql> Select EXPORT_SET(5, NULL,'N',',', 4); +--------------------------------+ | EXPORT_SET(5, NULL,'N',',', 4) | +--------------------------------+ | NULL | +--------------------------------+ 1 row in set (0.00 sec) mysql> Select EXPORT_SET(5, 'Y','N',',', NULL); +----------------------------------+ | EXPORT_SET(5, 'Y','N',',', NULL) | +----------------------------------+ | NULL | +----------------------------------+ 1 row in set (0.00 sec) mysql> Select EXPORT_SET(5, 'Y','N',NULL, 4); +--------------------------------+ | EXPORT_SET(5, 'Y','N',NULL, 4) | +--------------------------------+ | NULL | +--------------------------------+ 1 row in set (0.00 sec)
- Related Articles
- What MySQL returns if the argument of QUOTE() function is NULL?
- 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 COALESCE() function returns if it has a blank, but not NULL, as the first argument?
- 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 returns if we use NULL, as both the arguments, as one of the argument and as a separator, in CONCAT_WS() function?
- What MySQL TRIM() function returns if 1st argument(i.e. BOTH, LEADING, TRAILING) is not specified?
- What MySQL ASCII() function returns if I will provide NULL to it?
- When MySQL IN() function returns NULL?
- When MySQL MAKE_SET() function returns NULL?
- What MySQL MAKE_SET() function returns if there are all NULL at the place of strings?
- What MySQL MAKE_SET() function returns if the value of the bit is 1 and the first string is NULL?
- What MySQL returns if we provide value larger than 255 as argument to MySQL CHAR() function?
Advertisements