56,687
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE t1 LIKE testTable
CREATE TABLE t2 LIKE testTable
CREATE TABLE t3 LIKE testTable
alter table t1 ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC
alter table t2 ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC
alter table t3 ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC
CREATE TABLE tableALL LIKE testTable;
ALTER TABLE tableALL ENGINE=MERGE UNION=
(t1,t2,t3) INSERT_METHOD=LAST;
ALTER TABLE tableALL ENGINE=MERGE UNION=
(t1,t2,t3,t4) INSERT_METHOD=LAST; 把t4添加到UNION里