Hello All I have a table (about 72 GB of data).
When the table was created, not much attention was paid to the design aspect. For ex., id int(10) should only by tinyint(3) name char(35) should just be char(20) and many more like that. I do not have enough space on the hard drive to create a temp table. I have to re structure the table and I am seeking some suggestions. I plan to use ALTER table <tablename> MODIFY <COLUMNNAME>.... So I would be doing "Alter table host modify id tinyint(3) not null primary key auto_increment" Are there any Alerts/Comments/Suggestions for the approach? I have to modify almost all the pre-existing columns - is there a quicker way? Regards Aman Raheja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
