Please help: Innodb table could not drop a column# Database - 数据库
b*r
1 楼
mysql version 4.0.20a, on winxp. Innodb type table.
I use "alter table tbl_name drop col_name" to drop a column,
but it failed twice.
From the dos window on XP, the comman "alter table" hang on there for ever.
After reboot the machine, the column is still there,
and data in this column are still fine.
The table has about 20 million rolls. Is the size a prolbem?
Thanks for any help.
I use "alter table tbl_name drop col_name" to drop a column,
but it failed twice.
From the dos window on XP, the comman "alter table" hang on there for ever.
After reboot the machine, the column is still there,
and data in this column are still fine.
The table has about 20 million rolls. Is the size a prolbem?
Thanks for any help.
