blob: 3dd5c00d3d8b41d076ac851a97e3d8f5f93f32db (
plain)
1
2
3
4
5
6
|
drop table if exists t1,t2;
CREATE TABLE t1 (a INT, INDEX(a)) engine=innodb;
ALTER TABLE t1 RENAME TO t2, DISABLE KEYS;
Warnings:
Note 1031 Table storage engine for 't1' doesn't have this option
DROP TABLE t2;
|