On Fri, 2006-06-23 at 01:41 -0700, Blake Mitchell wrote: > This is what I ended up doing after looking at the MySQL docs: > > mysql> ALTER TABLE dbmail_messageblks CHANGE messageblk messageblk > longblob NOT NULL; > Query OK, 153840 rows affected (3 min 18.39 sec) > Records: 153840 Duplicates: 0 Warnings: 0
I put something equivalent into SVN: ALTER TABLE dbmail_messageblks MODIFY messageblk LONGBLOB NOT NULL; Something silly that MySQL does, though, is still take just as long to run this query even if the column type is already LONGBLOB NOT NULL. Oh well. Better to spend a few extra minutes than to have people out there with weird random truncations. Aaron
