DROP TABLE IF EXISTS TST,A,B,C,D,E,F; CREATE TABLE TST ( `col_int` int(11) DEFAULT NULL, `col_varchar_256_utf8` varchar(256) CHARACTER SET utf8 DEFAULT NULL, `col_varchar_256_latin1` varchar(256) DEFAULT NULL, `col_datetime_unique` datetime DEFAULT NULL, `col_int_unique` int(11) DEFAULT NULL, `col_varchar_10_utf8_unique` varchar(10) CHARACTER SET utf8 DEFAULT NULL, `col_varchar_256_utf8_unique` varchar(256) CHARACTER SET utf8 DEFAULT NULL, `col_char_16_latin1_key` char(16) DEFAULT NULL, `col_datetime_key` datetime DEFAULT NULL, `col_varchar_10_utf8` varchar(10) CHARACTER SET utf8 DEFAULT NULL, `col_char_16_latin1_unique` char(16) DEFAULT NULL, `pk` int(11) NOT NULL AUTO_INCREMENT, `col_varchar_10_latin1_unique` varchar(10) DEFAULT NULL, `col_varchar_10_latin1_key` varchar(10) DEFAULT NULL, `col_char_16_utf8_key` char(16) CHARACTER SET utf8 DEFAULT NULL, `col_varchar_10_latin1` varchar(10) DEFAULT NULL, `col_varchar_256_utf8_key` varchar(256) CHARACTER SET utf8 DEFAULT NULL, `col_varchar_256_latin1_unique` varchar(256) DEFAULT NULL, `col_datetime` datetime DEFAULT NULL, `col_varchar_10_utf8_key` varchar(10) CHARACTER SET utf8 DEFAULT NULL, `col_char_16_utf8` char(16) CHARACTER SET utf8 DEFAULT NULL, `col_char_16_latin1` char(16) DEFAULT NULL, `col_char_16_utf8_unique` char(16) CHARACTER SET utf8 DEFAULT NULL, `col_varchar_256_latin1_key` varchar(256) DEFAULT NULL, `col_int_key` int(11) DEFAULT NULL, PRIMARY KEY (`pk`), UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`), UNIQUE KEY `col_int_unique` (`col_int_unique`), UNIQUE KEY `col_varchar_10_utf8_unique` (`col_varchar_10_utf8_unique`), UNIQUE KEY `col_varchar_256_utf8_unique` (`col_varchar_256_utf8_unique`), UNIQUE KEY `col_char_16_latin1_unique` (`col_char_16_latin1_unique`), UNIQUE KEY `col_varchar_10_latin1_unique` (`col_varchar_10_latin1_unique`), UNIQUE KEY `col_varchar_256_latin1_unique` (`col_varchar_256_latin1_unique`), UNIQUE KEY `col_char_16_utf8_unique` (`col_char_16_utf8_unique`), KEY `col_char_16_latin1_key` (`col_char_16_latin1_key`), KEY `col_datetime_key` (`col_datetime_key`), KEY `col_varchar_10_latin1_key` (`col_varchar_10_latin1_key`), KEY `col_char_16_utf8_key` (`col_char_16_utf8_key`), KEY `col_varchar_256_utf8_key` (`col_varchar_256_utf8_key`), KEY `col_varchar_10_utf8_key` (`col_varchar_10_utf8_key`), KEY `col_varchar_256_latin1_key` (`col_varchar_256_latin1_key`), KEY `col_int_key` (`col_int_key`) ) ENGINE=MyISAM; CREATE TABLE A LIKE TST; ALTER TABLE A engine = ndbcluster; SHOW WARNINGS; CREATE TABLE B LIKE TST; ALTER TABLE B engine = ndbcluster; SHOW WARNINGS; CREATE TABLE C LIKE TST; ALTER TABLE C engine = ndbcluster; SHOW WARNINGS; CREATE TABLE D LIKE TST; ALTER TABLE D engine = ndbcluster; SHOW WARNINGS; CREATE TABLE E LIKE TST; ALTER TABLE E engine = ndbcluster; SHOW WARNINGS; CREATE TABLE F LIKE TST; ALTER TABLE F engine = ndbcluster; SHOW WARNINGS;