Thanks for the hint - i found it on MySQL.com 's documentation on ALTER
table
---
ALTER TABLE works by making a temporary copy of the original table. The
alteration is performed on the copy, then the original table is deleted
and the new one is renamed. .
--
Of course in th
I think you may need to use a scripted approach in order to avoid
overflowing your disk.
1. Create a new empty table with the correct structure.
2. Copy some "block" of records (like those with id values between 1 and
1000) into the new table
3. Delete the same records (the ones you just duplicat
Thanks Shawn
I did think about this approach due to the disk limitation.
I still want to know, if
"ALTER TABLE MODIFY ..."
can do the same for me and if it has imitations or if anyone has any
suggestions of why it should not be done, especially when I am dealing
with Gigs of data (more than 43
