

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
When MySQL MAKE_SET() function returns NULL?
MySQL MAKE_SET() function returns NULL if the value of the bit is NULL otherwise NULL at any other place is ignored by this function. Following example will demonstrate it −
Example
mysql> Select MAKE_SET(NULL, 'A','B','C'); +-----------------------------+ | MAKE_SET(NULL, 'A','B','C') | +-----------------------------+ | NULL | +-----------------------------+ 1 row in set (0.00 sec) mysql> Select MAKE_SET(2, NULL,'B',NULL); +----------------------------+ | MAKE_SET(2, NULL,'B',NULL) | +----------------------------+ | B | +----------------------------+ 1 row in set (0.00 sec)
- Related Questions & Answers
- When MySQL IN() function returns NULL?
- When MySQL FIND_IN_SET() function returns NULL as output?
- When MySQL LOCATE() function returns NULL as the output?
- When a MySQL arithmetic expression returns NULL?
- 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 ASCII() function returns if I will provide NULL to it?
- What MySQL EXPORT_SET() function returns if any of the argument is NULL?
- What MySQL returns if the search string, provided in FIELD() function, is NULL?
- What MySQL returns when we use DISTINCT clause with the column having multiple NULL values?
- How can I set 0 if a query returns a null value in MySQL?
- What MySQL COALESCE() function returns if all the arguments provided to it are NULL?
- When MySQL SUBSTRING_INDEX() function returns the same string, provided in the argument, as output?
- What MySQL MAKE_SET() function returns if there are all NULL at the place of strings?
- Return null for date_format when input is null in MySQL?
Advertisements