UNCOMPRES-Mysql

by Mohan 2012-09-21 09:45:09

UNCOMPRESS(string_to_uncompress) uncompresses a string compressed by the COMPRESS() function.
mysql>
mysql> SELECT UNCOMPRESS(COMPRESS('any string'));
+------------------------------------+
| UNCOMPRESS(COMPRESS('any string')) |
+------------------------------------+
| any string |
+------------------------------------+
1 row in set (0.00 sec)

mysql>
mysql> SELECT UNCOMPRESS('any string');
+--------------------------+
| UNCOMPRESS('any string') |
+--------------------------+
| NULL |
+--------------------------+
1 row in set, 1 warning (0.00 sec)

mysql>
510
like
0
dislike
0
mail
flag

You must LOGIN to add comments