SELECT LENGTH(COMPRESS(REPEAT('a',16))); : COMPRESS « Encryption Compression Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Encryption Compression Functions
  3. COMPRESS
mysql>
mysql> SELECT LENGTH(COMPRESS(REPEAT('a',16)));
+----------------------------------+
| LENGTH(COMPRESS(REPEAT('a',16))) |
+----------------------------------+
|                               15 |
+----------------------------------+
1 row in set (0.00 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)));