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






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