b****r
发帖数: 113 | 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. | s***e
发帖数: 284 | 2 try a small table first. if it works, it's size problem
【在 b****r 的大作中提到】
: 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.
|
|
