1
DROP TABLE IF EXISTS `ｱｱｱ`;
2
DROP TABLE IF EXISTS `ｲｲｲ`;
3
DROP TABLE IF EXISTS `あああ`;
4
DROP TABLE IF EXISTS `いいい`;
5
DROP TABLE IF EXISTS `龖龖龖`;
6
DROP TABLE IF EXISTS `龗龗龗`;
8
SET character_set_database = utf8;
9
CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
10
CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
11
CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
12
CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
13
CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
14
CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
15
INSERT INTO `ｱｱｱ` VALUES ('ｱｱｱｱｱ'),('ｲｲｲｲｲ'),('ｳｳｳｳｳ');
16
INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
17
INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
18
ALTER TABLE `ｱｱｱ` ADD `ｶｶｶ` char(1) FIRST;
19
ALTER TABLE `ｱｱｱ` ADD `ｸｸｸ` char(1) AFTER `ｷｷｷ`;
20
ALTER TABLE `ｱｱｱ` ADD `ｹｹｹ` char(1);
21
ALTER TABLE `ｱｱｱ` ADD INDEX (`ｶｶｶ`);
22
ALTER TABLE `ｱｱｱ` ADD PRIMARY KEY (`ｷｷｷ`);
23
ALTER TABLE `ｱｱｱ` ADD UNIQUE (`ｸｸｸ`);
24
ALTER TABLE `ｱｱｱ` CHANGE `ｶｶｶ` `ｶｶ` char(1);
25
ALTER TABLE `ｱｱｱ` MODIFY `ｷｷｷ` char(6);
32
Field Type Null Key Default Extra
33
ｶｶ char(1) YES MUL NULL
35
ｸｸｸ char(1) YES UNI NULL
37
SHOW CREATE TABLE `ｱｱｱ`;
39
ｱｱｱ CREATE TABLE `ｱｱｱ` (
40
`ｶｶ` char(1) default NULL,
41
`ｷｷｷ` char(6) NOT NULL default '',
42
`ｸｸｸ` char(1) default NULL,
43
`ｹｹｹ` char(1) default NULL,
45
UNIQUE KEY `ｸｸｸ` (`ｸｸｸ`),
47
) ENGINE=InnoDB DEFAULT CHARSET=utf8
48
ALTER TABLE `ｱｱｱ` DROP INDEX `ｶｶｶ`;
49
ALTER TABLE `ｱｱｱ` DROP PRIMARY KEY;
50
ALTER TABLE `ｱｱｱ` DROP INDEX `ｸｸｸ`;
51
ALTER TABLE `ｱｱｱ` DROP `ｶｶ`;
52
ALTER TABLE `ｱｱｱ` DROP `ｸｸｸ`;
53
ALTER TABLE `ｱｱｱ` DROP `ｹｹｹ`;
60
Field Type Null Key Default Extra
62
SHOW CREATE TABLE `ｱｱｱ`;
64
ｱｱｱ CREATE TABLE `ｱｱｱ` (
65
`ｷｷｷ` char(6) NOT NULL default ''
66
) ENGINE=InnoDB DEFAULT CHARSET=utf8
67
ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
68
ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
69
ALTER TABLE `あああ` ADD `けけけ` char(1);
70
ALTER TABLE `あああ` ADD INDEX (`かかか`);
71
ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
72
ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
73
ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
74
ALTER TABLE `あああ` MODIFY `ききき` char(6);
81
Field Type Null Key Default Extra
82
かか char(1) YES MUL NULL
84
くくく char(1) YES UNI NULL
86
SHOW CREATE TABLE `あああ`;
88
あああ CREATE TABLE `あああ` (
89
`かか` char(1) default NULL,
90
`ききき` char(6) NOT NULL default '',
91
`くくく` char(1) default NULL,
92
`けけけ` char(1) default NULL,
94
UNIQUE KEY `くくく` (`くくく`),
96
) ENGINE=InnoDB DEFAULT CHARSET=utf8
97
ALTER TABLE `あああ` DROP INDEX `かかか`;
98
ALTER TABLE `あああ` DROP PRIMARY KEY;
99
ALTER TABLE `あああ` DROP INDEX `くくく`;
100
ALTER TABLE `あああ` DROP `かか`;
101
ALTER TABLE `あああ` DROP `くくく`;
102
ALTER TABLE `あああ` DROP `けけけ`;
109
Field Type Null Key Default Extra
111
SHOW CREATE TABLE `あああ`;
113
あああ CREATE TABLE `あああ` (
114
`ききき` char(6) NOT NULL default ''
115
) ENGINE=InnoDB DEFAULT CHARSET=utf8
116
ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
117
ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
118
ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
119
ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`);
120
ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`);
121
ALTER TABLE `龖龖龖` ADD UNIQUE (`丅丅丅`);
122
ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1);
123
ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6);
130
Field Type Null Key Default Extra
131
丄丄 char(1) YES MUL NULL
133
丅丅丅 char(1) YES UNI NULL
135
SHOW CREATE TABLE `龖龖龖`;
137
龖龖龖 CREATE TABLE `龖龖龖` (
138
`丄丄` char(1) default NULL,
139
`丂丂丂` char(6) NOT NULL default '',
140
`丅丅丅` char(1) default NULL,
141
`乚乚乚` char(1) default NULL,
143
UNIQUE KEY `丅丅丅` (`丅丅丅`),
145
) ENGINE=InnoDB DEFAULT CHARSET=utf8
146
ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
147
ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
148
ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
149
ALTER TABLE `龖龖龖` DROP `丄丄`;
150
ALTER TABLE `龖龖龖` DROP `丅丅丅`;
151
ALTER TABLE `龖龖龖` DROP `乚乚乚`;
158
Field Type Null Key Default Extra
160
SHOW CREATE TABLE `龖龖龖`;
162
龖龖龖 CREATE TABLE `龖龖龖` (
163
`丂丂丂` char(6) NOT NULL default ''
164
) ENGINE=InnoDB DEFAULT CHARSET=utf8
171
CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
172
CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
173
CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
174
CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
175
CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
176
CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
177
INSERT INTO `ｱｱｱ` VALUES ('ｱｱｱｱｱ'),('ｲｲｲｲｲ'),('ｳｳｳｳｳ');
178
INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
179
INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
180
ALTER TABLE `ｱｱｱ` ADD `ｶｶｶ` char(1) FIRST;
181
ALTER TABLE `ｱｱｱ` ADD `ｸｸｸ` char(1) AFTER `ｷｷｷ`;
182
ALTER TABLE `ｱｱｱ` ADD `ｹｹｹ` char(1);
183
ALTER TABLE `ｱｱｱ` ADD INDEX (`ｶｶｶ`);
184
ALTER TABLE `ｱｱｱ` ADD PRIMARY KEY (`ｷｷｷ`);
185
ALTER TABLE `ｱｱｱ` ADD UNIQUE (`ｸｸｸ`);
186
ALTER TABLE `ｱｱｱ` CHANGE `ｶｶｶ` `ｶｶ` char(1);
187
ALTER TABLE `ｱｱｱ` MODIFY `ｷｷｷ` char(6);
194
Field Type Null Key Default Extra
195
ｶｶ char(1) YES MUL NULL
197
ｸｸｸ char(1) YES UNI NULL
199
SHOW CREATE TABLE `ｱｱｱ`;
201
ｱｱｱ CREATE TABLE `ｱｱｱ` (
202
`ｶｶ` char(1) default NULL,
203
`ｷｷｷ` char(6) NOT NULL default '',
204
`ｸｸｸ` char(1) default NULL,
205
`ｹｹｹ` char(1) default NULL,
207
UNIQUE KEY `ｸｸｸ` (`ｸｸｸ`),
209
) ENGINE=MyISAM DEFAULT CHARSET=utf8
210
ALTER TABLE `ｱｱｱ` DROP INDEX `ｶｶｶ`;
211
ALTER TABLE `ｱｱｱ` DROP PRIMARY KEY;
212
ALTER TABLE `ｱｱｱ` DROP INDEX `ｸｸｸ`;
213
ALTER TABLE `ｱｱｱ` DROP `ｶｶ`;
214
ALTER TABLE `ｱｱｱ` DROP `ｸｸｸ`;
215
ALTER TABLE `ｱｱｱ` DROP `ｹｹｹ`;
222
Field Type Null Key Default Extra
224
SHOW CREATE TABLE `ｱｱｱ`;
226
ｱｱｱ CREATE TABLE `ｱｱｱ` (
227
`ｷｷｷ` char(6) NOT NULL default ''
228
) ENGINE=MyISAM DEFAULT CHARSET=utf8
229
ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
230
ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
231
ALTER TABLE `あああ` ADD `けけけ` char(1);
232
ALTER TABLE `あああ` ADD INDEX (`かかか`);
233
ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
234
ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
235
ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
236
ALTER TABLE `あああ` MODIFY `ききき` char(6);
243
Field Type Null Key Default Extra
244
かか char(1) YES MUL NULL
246
くくく char(1) YES UNI NULL
248
SHOW CREATE TABLE `あああ`;
250
あああ CREATE TABLE `あああ` (
251
`かか` char(1) default NULL,
252
`ききき` char(6) NOT NULL default '',
253
`くくく` char(1) default NULL,
254
`けけけ` char(1) default NULL,
256
UNIQUE KEY `くくく` (`くくく`),
258
) ENGINE=MyISAM DEFAULT CHARSET=utf8
259
ALTER TABLE `あああ` DROP INDEX `かかか`;
260
ALTER TABLE `あああ` DROP PRIMARY KEY;
261
ALTER TABLE `あああ` DROP INDEX `くくく`;
262
ALTER TABLE `あああ` DROP `かか`;
263
ALTER TABLE `あああ` DROP `くくく`;
264
ALTER TABLE `あああ` DROP `けけけ`;
271
Field Type Null Key Default Extra
273
SHOW CREATE TABLE `あああ`;
275
あああ CREATE TABLE `あああ` (
276
`ききき` char(6) NOT NULL default ''
277
) ENGINE=MyISAM DEFAULT CHARSET=utf8
278
ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
279
ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
280
ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
281
ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`);
282
ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`);
283
ALTER TABLE `龖龖龖` ADD UNIQUE (`丅丅丅`);
284
ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1);
285
ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6);
292
Field Type Null Key Default Extra
293
丄丄 char(1) YES MUL NULL
295
丅丅丅 char(1) YES UNI NULL
297
SHOW CREATE TABLE `龖龖龖`;
299
龖龖龖 CREATE TABLE `龖龖龖` (
300
`丄丄` char(1) default NULL,
301
`丂丂丂` char(6) NOT NULL default '',
302
`丅丅丅` char(1) default NULL,
303
`乚乚乚` char(1) default NULL,
305
UNIQUE KEY `丅丅丅` (`丅丅丅`),
307
) ENGINE=MyISAM DEFAULT CHARSET=utf8
308
ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
309
ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
310
ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
311
ALTER TABLE `龖龖龖` DROP `丄丄`;
312
ALTER TABLE `龖龖龖` DROP `丅丅丅`;
313
ALTER TABLE `龖龖龖` DROP `乚乚乚`;
320
Field Type Null Key Default Extra
322
SHOW CREATE TABLE `龖龖龖`;
324
龖龖龖 CREATE TABLE `龖龖龖` (
325
`丂丂丂` char(6) NOT NULL default ''
326
) ENGINE=MyISAM DEFAULT CHARSET=utf8
333
CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = utf8 engine=HEAP;
334
CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = utf8 engine=HEAP;
335
CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = utf8 engine=HEAP;
336
CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = utf8 engine=HEAP;
337
CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = utf8 engine=HEAP;
338
CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = utf8 engine=HEAP;
339
INSERT INTO `ｱｱｱ` VALUES ('ｱｱｱｱｱ'),('ｲｲｲｲｲ'),('ｳｳｳｳｳ');
340
INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
341
INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
342
ALTER TABLE `ｱｱｱ` ADD `ｶｶｶ` char(1) FIRST;
343
ALTER TABLE `ｱｱｱ` ADD `ｸｸｸ` char(1) AFTER `ｷｷｷ`;
344
ALTER TABLE `ｱｱｱ` ADD `ｹｹｹ` char(1);
345
ALTER TABLE `ｱｱｱ` ADD INDEX (`ｶｶｶ`);
346
ALTER TABLE `ｱｱｱ` ADD PRIMARY KEY (`ｷｷｷ`);
347
ALTER TABLE `ｱｱｱ` ADD UNIQUE (`ｸｸｸ`);
348
ALTER TABLE `ｱｱｱ` CHANGE `ｶｶｶ` `ｶｶ` char(1);
349
ALTER TABLE `ｱｱｱ` MODIFY `ｷｷｷ` char(6);
356
Field Type Null Key Default Extra
357
ｶｶ char(1) YES MUL NULL
359
ｸｸｸ char(1) YES UNI NULL
361
SHOW CREATE TABLE `ｱｱｱ`;
363
ｱｱｱ CREATE TABLE `ｱｱｱ` (
364
`ｶｶ` char(1) default NULL,
365
`ｷｷｷ` char(6) NOT NULL default '',
366
`ｸｸｸ` char(1) default NULL,
367
`ｹｹｹ` char(1) default NULL,
369
UNIQUE KEY `ｸｸｸ` (`ｸｸｸ`),
371
) ENGINE=MEMORY DEFAULT CHARSET=utf8
372
ALTER TABLE `ｱｱｱ` DROP INDEX `ｶｶｶ`;
373
ALTER TABLE `ｱｱｱ` DROP PRIMARY KEY;
374
ALTER TABLE `ｱｱｱ` DROP INDEX `ｸｸｸ`;
375
ALTER TABLE `ｱｱｱ` DROP `ｶｶ`;
376
ALTER TABLE `ｱｱｱ` DROP `ｸｸｸ`;
377
ALTER TABLE `ｱｱｱ` DROP `ｹｹｹ`;
384
Field Type Null Key Default Extra
386
SHOW CREATE TABLE `ｱｱｱ`;
388
ｱｱｱ CREATE TABLE `ｱｱｱ` (
389
`ｷｷｷ` char(6) NOT NULL default ''
390
) ENGINE=MEMORY DEFAULT CHARSET=utf8
391
ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
392
ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
393
ALTER TABLE `あああ` ADD `けけけ` char(1);
394
ALTER TABLE `あああ` ADD INDEX (`かかか`);
395
ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
396
ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
397
ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
398
ALTER TABLE `あああ` MODIFY `ききき` char(6);
405
Field Type Null Key Default Extra
406
かか char(1) YES MUL NULL
408
くくく char(1) YES UNI NULL
410
SHOW CREATE TABLE `あああ`;
412
あああ CREATE TABLE `あああ` (
413
`かか` char(1) default NULL,
414
`ききき` char(6) NOT NULL default '',
415
`くくく` char(1) default NULL,
416
`けけけ` char(1) default NULL,
418
UNIQUE KEY `くくく` (`くくく`),
420
) ENGINE=MEMORY DEFAULT CHARSET=utf8
421
ALTER TABLE `あああ` DROP INDEX `かかか`;
422
ALTER TABLE `あああ` DROP PRIMARY KEY;
423
ALTER TABLE `あああ` DROP INDEX `くくく`;
424
ALTER TABLE `あああ` DROP `かか`;
425
ALTER TABLE `あああ` DROP `くくく`;
426
ALTER TABLE `あああ` DROP `けけけ`;
433
Field Type Null Key Default Extra
435
SHOW CREATE TABLE `あああ`;
437
あああ CREATE TABLE `あああ` (
438
`ききき` char(6) NOT NULL default ''
439
) ENGINE=MEMORY DEFAULT CHARSET=utf8
440
ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
441
ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
442
ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
443
ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`);
444
ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`);
445
ALTER TABLE `龖龖龖` ADD UNIQUE (`丅丅丅`);
446
ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1);
447
ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6);
454
Field Type Null Key Default Extra
455
丄丄 char(1) YES MUL NULL
457
丅丅丅 char(1) YES UNI NULL
459
SHOW CREATE TABLE `龖龖龖`;
461
龖龖龖 CREATE TABLE `龖龖龖` (
462
`丄丄` char(1) default NULL,
463
`丂丂丂` char(6) NOT NULL default '',
464
`丅丅丅` char(1) default NULL,
465
`乚乚乚` char(1) default NULL,
467
UNIQUE KEY `丅丅丅` (`丅丅丅`),
469
) ENGINE=MEMORY DEFAULT CHARSET=utf8
470
ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
471
ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
472
ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
473
ALTER TABLE `龖龖龖` DROP `丄丄`;
474
ALTER TABLE `龖龖龖` DROP `丅丅丅`;
475
ALTER TABLE `龖龖龖` DROP `乚乚乚`;
482
Field Type Null Key Default Extra
484
SHOW CREATE TABLE `龖龖龖`;
486
龖龖龖 CREATE TABLE `龖龖龖` (
487
`丂丂丂` char(6) NOT NULL default ''
488
) ENGINE=MEMORY DEFAULT CHARSET=utf8
495
CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = utf8 engine=BDB;
496
CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = utf8 engine=BDB;
497
CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = utf8 engine=BDB;
498
CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = utf8 engine=BDB;
499
CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = utf8 engine=BDB;
500
CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = utf8 engine=BDB;
501
INSERT INTO `ｱｱｱ` VALUES ('ｱｱｱｱｱ'),('ｲｲｲｲｲ'),('ｳｳｳｳｳ');
502
INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
503
INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
504
ALTER TABLE `ｱｱｱ` ADD `ｶｶｶ` char(1) FIRST;
505
ALTER TABLE `ｱｱｱ` ADD `ｸｸｸ` char(1) AFTER `ｷｷｷ`;
506
ALTER TABLE `ｱｱｱ` ADD `ｹｹｹ` char(1);
507
ALTER TABLE `ｱｱｱ` ADD INDEX (`ｶｶｶ`);
508
ALTER TABLE `ｱｱｱ` ADD PRIMARY KEY (`ｷｷｷ`);
509
ALTER TABLE `ｱｱｱ` CHANGE `ｶｶｶ` `ｶｶ` char(1);
510
ALTER TABLE `ｱｱｱ` MODIFY `ｷｷｷ` char(6);
517
Field Type Null Key Default Extra
518
ｶｶ char(1) YES MUL NULL
522
SHOW CREATE TABLE `ｱｱｱ`;
524
ｱｱｱ CREATE TABLE `ｱｱｱ` (
525
`ｶｶ` char(1) default NULL,
526
`ｷｷｷ` char(6) NOT NULL default '',
527
`ｸｸｸ` char(1) default NULL,
528
`ｹｹｹ` char(1) default NULL,
531
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
532
ALTER TABLE `ｱｱｱ` DROP INDEX `ｶｶｶ`;
533
ALTER TABLE `ｱｱｱ` DROP PRIMARY KEY;
534
ALTER TABLE `ｱｱｱ` DROP `ｶｶ`;
535
ALTER TABLE `ｱｱｱ` DROP `ｸｸｸ`;
536
ALTER TABLE `ｱｱｱ` DROP `ｹｹｹ`;
543
Field Type Null Key Default Extra
545
SHOW CREATE TABLE `ｱｱｱ`;
547
ｱｱｱ CREATE TABLE `ｱｱｱ` (
548
`ｷｷｷ` char(6) NOT NULL default ''
549
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
550
ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
551
ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
552
ALTER TABLE `あああ` ADD `けけけ` char(1);
553
ALTER TABLE `あああ` ADD INDEX (`かかか`);
554
ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
555
ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
556
ALTER TABLE `あああ` MODIFY `ききき` char(6);
563
Field Type Null Key Default Extra
564
かか char(1) YES MUL NULL
568
SHOW CREATE TABLE `あああ`;
570
あああ CREATE TABLE `あああ` (
571
`かか` char(1) default NULL,
572
`ききき` char(6) NOT NULL default '',
573
`くくく` char(1) default NULL,
574
`けけけ` char(1) default NULL,
577
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
578
ALTER TABLE `あああ` DROP INDEX `かかか`;
579
ALTER TABLE `あああ` DROP PRIMARY KEY;
580
ALTER TABLE `あああ` DROP `かか`;
581
ALTER TABLE `あああ` DROP `くくく`;
582
ALTER TABLE `あああ` DROP `けけけ`;
589
Field Type Null Key Default Extra
591
SHOW CREATE TABLE `あああ`;
593
あああ CREATE TABLE `あああ` (
594
`ききき` char(6) NOT NULL default ''
595
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
596
ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
597
ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
598
ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
599
ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`);
600
ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`);
601
ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1);
602
ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6);
609
Field Type Null Key Default Extra
610
丄丄 char(1) YES MUL NULL
614
SHOW CREATE TABLE `龖龖龖`;
616
龖龖龖 CREATE TABLE `龖龖龖` (
617
`丄丄` char(1) default NULL,
618
`丂丂丂` char(6) NOT NULL default '',
619
`丅丅丅` char(1) default NULL,
620
`乚乚乚` char(1) default NULL,
623
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
624
ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
625
ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
626
ALTER TABLE `龖龖龖` DROP `丄丄`;
627
ALTER TABLE `龖龖龖` DROP `丅丅丅`;
628
ALTER TABLE `龖龖龖` DROP `乚乚乚`;
635
Field Type Null Key Default Extra
637
SHOW CREATE TABLE `龖龖龖`;
639
龖龖龖 CREATE TABLE `龖龖龖` (
640
`丂丂丂` char(6) NOT NULL default ''
641
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
added
removed
mysql-test/suite/jp/r/jp_alter_utf8.result
