MAKE_SET(0,'a','b','c'); : MAKE_SET « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. MAKE_SET
mysql>
mysql>
mysql> SELECT MAKE_SET(0,'a','b','c');
+-------------------------+
| MAKE_SET(0,'a','b','c') |
+-------------------------+
|                         |
+-------------------------+
1 row in set (0.02 sec)








23.27.MAKE_SET
23.27.1.MAKE_SET(bits,str1,str2,...): Returns a string containing substrings separated by ',' characters
23.27.2.MAKE_SET(1 | 4,'A','B','C');
23.27.3.MAKE_SET(1 | 4,'A','B',NULL,'C')
23.27.4.MAKE_SET(0,'a','b','c');
23.27.5.Make first name and last name as a set