SELECT LENGTH(COMPRESS('')); : COMPRESS « Encryption Compression Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Encryption Compression Functions
  3. COMPRESS
mysql>
mysql> SELECT LENGTH(COMPRESS(''));
+----------------------+
| LENGTH(COMPRESS('')) |
+----------------------+
|                    0 |
+----------------------+
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)));