Update MySQL DB to Compress Blobs

Question

If there a one-shot way to update a range of IDs (e.g. WHERE ID>10 AND ID<1000) to compress a blob column (e.g. data)?

e.g.

UPDATE `table` SET `data`=(SELECT COMPRESS(`data`) FROM `table` WHERE ID=1) WHERE ID=1

but for a range of IDs instead of a single ID. I need to update around 1500 rows that were incorrectly inserted into a DB without compression.

Sabeen Malik · Accepted Answer · 2011-08-09 02:11:07Z

5

Wont this work?:

UPDATE `table` SET `data`=  COMPRESS(`data`) WHERE ID > 10 AND ID < 1000

answered Aug 9, 2011 at 2:11

Sabeen Malik

10.9k4 gold badges37 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

yup; durh. Obvious answer to obvious problem. Cheers