Encryption Compression Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Encryption Compression Functions
  4. SELECT LENGTH(COMPRESS(REPEAT(a,16)))
mysql>
mysql> SELECT LENGTH(COMPRESS(REPEAT('a',16)));
+----------------------------------+
| LENGTH(COMPRESS(REPEAT('a',16))) |
+----------------------------------+
|                               15 |
+----------------------------------+
1 row in set (0.00 sec)
mysql>