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 this case, with my hard disk limit, I can not just modify columns. Thanks Aman Raheja Check out http://www.techquotes.com On Thu, 2004-07-08 at 16:26, Quentin Bennett wrote: > Hi, > > Alter table will create a whole new table, so you may have disk issues there. > > Check in the manual (I'm not sure where!) about how MySQL reclaims disk space when > you delete records - it may not reduce the size of the file until you do a compress > or optimise of some sort. > > Regards > > Quentin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]