COMPRESS(string_to_compress) compresses a string and returns the result as a binary string : COMPRESS « Encryption Compression Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Encryption Compression Functions
  3. COMPRESS
mysql>
mysql> SELECT LENGTH(COMPRESS(REPEAT('a',1000)));
+------------------------------------+
| LENGTH(COMPRESS(REPEAT('a',1000))) |
+------------------------------------+
|                                 21 |
+------------------------------------+
1 row in set (0.02 sec)

mysql>








19.4.COMPRESS
19.4.1.COMPRESS(string_to_compress) compresses a string and returns the result as a binary string
19.4.2.SELECT LENGTH(COMPRESS(''));
19.4.3.SELECT LENGTH(COMPRESS('a'));
19.4.4.SELECT LENGTH(COMPRESS(REPEAT('a',16)));