Home  >  Article  >  Database  >  What does the MySQL MAKE_SET() function return if the value of this bit is 1 and the first string is NULL?

What does the MySQL MAKE_SET() function return if the value of this bit is 1 and the first string is NULL?

WBOY
WBOYforward
2023-08-24 17:49:12802browse

如果该位的值为 1 并且第一个字符串为 NULL,MySQL MAKE_SET() 函数返回什么?

MySQL MAKE_SET() function returns a null value when the bit's value is 1 and the first string is NULL. The following example will demonstrate this concept −

Example

mysql> Select MAKE_SET(1, NULL,'A','B');
+---------------------------+
| MAKE_SET(1, NULL,'A','B') |
+---------------------------+
|                           |
+---------------------------+
1 row in set (0.00 sec)

The above is the detailed content of What does the MySQL MAKE_SET() function return if the value of this bit is 1 and the first string is NULL?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete