298
298
t1 0 a 2 b A 300 NULL NULL YES BTREE
299
299
t1 1 b 1 b A 100 NULL NULL YES BTREE
301
CREATE TABLE t1 (i int(10), index(i) );
301
CREATE TABLE t1 (i int(10), index(i) ) ENGINE=MyISAM;
302
302
ALTER TABLE t1 DISABLE KEYS;
303
303
INSERT DELAYED INTO t1 VALUES(1),(2),(3);
304
304
ALTER TABLE t1 ENABLE KEYS;
1184
1184
Table Op Msg_type Msg_text
1185
1185
test.t1 check status OK
1187
DROP TABLE IF EXISTS t1;
1188
CREATE TABLE t1 (id int, c int) character set latin1;
1189
INSERT INTO t1 VALUES (1,1);
1190
ALTER TABLE t1 CHANGE c d int;
1192
info: Records: 0 Duplicates: 0 Warnings: 0
1193
ALTER TABLE t1 CHANGE d c int;
1195
info: Records: 0 Duplicates: 0 Warnings: 0
1196
ALTER TABLE t1 MODIFY c VARCHAR(10);
1198
info: Records: 1 Duplicates: 0 Warnings: 0
1199
ALTER TABLE t1 CHANGE c d varchar(10);
1201
info: Records: 0 Duplicates: 0 Warnings: 0
1202
ALTER TABLE t1 CHANGE d c varchar(10);
1204
info: Records: 0 Duplicates: 0 Warnings: 0
1206
DROP TABLE IF EXISTS t1;
1207
CREATE TABLE t1 (id int, c int) character set utf8;
1208
INSERT INTO t1 VALUES (1,1);
1209
ALTER TABLE t1 CHANGE c d int;
1211
info: Records: 0 Duplicates: 0 Warnings: 0
1212
ALTER TABLE t1 CHANGE d c int;
1214
info: Records: 0 Duplicates: 0 Warnings: 0
1215
ALTER TABLE t1 MODIFY c VARCHAR(10);
1217
info: Records: 1 Duplicates: 0 Warnings: 0
1218
ALTER TABLE t1 CHANGE c d varchar(10);
1220
info: Records: 0 Duplicates: 0 Warnings: 0
1221
ALTER TABLE t1 CHANGE d c varchar(10);
1223
info: Records: 0 Duplicates: 0 Warnings: 0