CodesJava

Easy learning with example program codes

EXPORT_SET() FUNCTION in MySQL

EXPORT_SET() FUNCTION
The MySQL EXPORT_SET function is used to get string for each bit set.

Syntax:

EXPORT_SET( bits, on, off, separator, number_of_bits )

Example:

mysql> SELECT EXPORT_SET ( 5, ‘a’, ‘b’, ‘,’, 4 );

Output:

a,b,a,b
Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status