Mega Code Archive

 

Categories / MySQL Tutorial / Encryption Compression Functions

 

COMPRESS(string_to_compress) compresses a string and returns the result as a binary string

mysql> mysql> SELECT LENGTH(COMPRESS(REPEAT('a',1000))); +------------------------------------+ | LENGTH(COMPRESS(REPEAT('a',1000))) | +------------------------------------+ |                                 21 | +------------------------------------+ 1 row in set (0.02 sec) mysql>