
- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
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 Articles
- 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 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 first argument of INTERVAL() function is NULL?
- What MySQL returns if the search string, provided in FIELD() function, is NULL?
- 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?
- What MySQL returns when we use DISTINCT clause with the column having multiple NULL values?
- What MySQL MAKE_SET() function returns if there are all NULL at the place of strings?
- What MySQL returns if the list of strings, provided as argument in FIELD() function, are NULL?
- What MySQL COUNT() function returns if there are some NULL values stored in a column also?

Advertisements