Encryption Compression Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Encryption Compression Functions
  4. 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>