CodesJava

Easy learning with example program codes

MAKE_SET() FUNCTION in MySQL

MAKE_SET() FUNCTION
The MySQL MAKE_SET function is used to get values from set for the given bit.

Syntax:

MAKE_SET (bits, string_1, string_2, … string_n );

Parameters:
bits: It is used to specify the bits to return.
string_1, string_2, … string_n: It is used to specify a list of strings.

Example:

mysql> SELECT MAKE_SET (1, ‘a’, ‘b’, ‘c’, ‘d’ );

Output:

‘a’
Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status