MySql: How to know if an entry is compressed or not
Posted
by Guy
on Stack Overflow
See other posts from Stack Overflow
or by Guy
Published on 2010-04-04T14:22:35Z
Indexed on
2010/04/04
14:33 UTC
Read the original article
Hit count: 157
I'm working with python and mysql and I want to verify that a certain entry is compressed in the db. Ie:
cur = db.getCursor()
cur.execute('''select compressed_column from table where id=12345''')
res = cur.fetchall()
at this point I would like to verify that the entry is compressed (ie in order to work with the data you would have to use select uncompress(compressed_column)..
). Ideas?
© Stack Overflow or respective owner