MySQL Tutorial/Encryption Compression Functions/COMPRESS

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

   <source lang="sql">

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

SELECT LENGTH(COMPRESS(""));

   <source lang="sql">

mysql> mysql> SELECT LENGTH(COMPRESS("")); +----------------------+ | LENGTH(COMPRESS("")) | +----------------------+ | 0 | +----------------------+ 1 row in set (0.00 sec) mysql></source>

SELECT LENGTH(COMPRESS("a"));

   <source lang="sql">

mysql> mysql> SELECT LENGTH(COMPRESS("a")); +-----------------------+ | LENGTH(COMPRESS("a")) | +-----------------------+ | 13 | +-----------------------+ 1 row in set (0.00 sec) mysql></source>

SELECT LENGTH(COMPRESS(REPEAT("a",16)));

   <source lang="sql">

mysql> mysql> SELECT LENGTH(COMPRESS(REPEAT("a",16))); +----------------------------------+ | LENGTH(COMPRESS(REPEAT("a",16))) | +----------------------------------+ | 15 | +----------------------------------+ 1 row in set (0.00 sec) mysql></source>