Debian Codegraph @

mysql-test/suite/jp/r/jp_alter_utf8.result

raw
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 `龗龗龗`;
7 SET NAMES utf8;
8 Warnings:
9 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
10 SET character_set_database = utf8;
11 Warnings:
12 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
13 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
14 CREATE TABLE `アアア`(`キキキ` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
15 Warnings:
16 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
17 CREATE TABLE `イイイ`(`ケケケ` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
18 Warnings:
19 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
20 CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
21 Warnings:
22 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
23 CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
24 Warnings:
25 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
26 CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
27 Warnings:
28 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
29 CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
30 Warnings:
31 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
32 INSERT INTO `アアア` VALUES ('アアアアア'),('イイイイイ'),('ウウウウウ');
33 INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
34 INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
35 ALTER TABLE `アアア` ADD `カカカ` char(1) FIRST;
36 ALTER TABLE `アアア` ADD `ククク` char(1) AFTER `キキキ`;
37 ALTER TABLE `アアア` ADD `ケケケ` char(1);
38 ALTER TABLE `アアア` ADD INDEX (`カカカ`);
39 ALTER TABLE `アアア` ADD PRIMARY KEY (`キキキ`);
40 ALTER TABLE `アアア` ADD UNIQUE (`ククク`);
41 ALTER TABLE `アアア` CHANGE `カカカ` `カカ` char(1);
42 ALTER TABLE `アアア` MODIFY `キキキ` char(6);
43 SELECT * FROM `アアア`;
44 カカ キキキ ククク ケケケ
45 NULL アアアアア NULL NULL
46 NULL イイイイイ NULL NULL
47 NULL ウウウウウ NULL NULL
48 DESC `アアア`;
49 Field Type Null Key Default Extra
50 カカ char(1) YES MUL NULL
51 キキキ char(6) NO PRI NULL
52 ククク char(1) YES UNI NULL
53 ケケケ char(1) YES NULL
54 SHOW CREATE TABLE `アアア`;
55 Table Create Table
56 アアア CREATE TABLE `アアア` (
57 `カカ` char(1) DEFAULT NULL,
58 `キキキ` char(6) NOT NULL,
59 `ククク` char(1) DEFAULT NULL,
60 `ケケケ` char(1) DEFAULT NULL,
61 PRIMARY KEY (`キキキ`),
62 UNIQUE KEY `ククク` (`ククク`),
63 KEY `カカカ` (`カカ`)
64 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
65 ALTER TABLE `アアア` DROP INDEX `カカカ`;
66 ALTER TABLE `アアア` DROP PRIMARY KEY;
67 ALTER TABLE `アアア` DROP INDEX `ククク`;
68 ALTER TABLE `アアア` DROP `カカ`;
69 ALTER TABLE `アアア` DROP `ククク`;
70 ALTER TABLE `アアア` DROP `ケケケ`;
71 SELECT * FROM `アアア`;
72 キキキ
73 アアアアア
74 イイイイイ
75 ウウウウウ
76 DESC `アアア`;
77 Field Type Null Key Default Extra
78 キキキ char(6) NO NULL
79 SHOW CREATE TABLE `アアア`;
80 Table Create Table
81 アアア CREATE TABLE `アアア` (
82 `キキキ` char(6) NOT NULL
83 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
84 ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
85 ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
86 ALTER TABLE `あああ` ADD `けけけ` char(1);
87 ALTER TABLE `あああ` ADD INDEX (`かかか`);
88 ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
89 ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
90 ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
91 ALTER TABLE `あああ` MODIFY `ききき` char(6);
92 SELECT * FROM `あああ`;
93 かか ききき くくく けけけ
94 NULL あああああ NULL NULL
95 NULL いいいいい NULL NULL
96 NULL ううううう NULL NULL
97 DESC `あああ`;
98 Field Type Null Key Default Extra
99 かか char(1) YES MUL NULL
100 ききき char(6) NO PRI NULL
101 くくく char(1) YES UNI NULL
102 けけけ char(1) YES NULL
103 SHOW CREATE TABLE `あああ`;
104 Table Create Table
105 あああ CREATE TABLE `あああ` (
106 `かか` char(1) DEFAULT NULL,
107 `ききき` char(6) NOT NULL,
108 `くくく` char(1) DEFAULT NULL,
109 `けけけ` char(1) DEFAULT NULL,
110 PRIMARY KEY (`ききき`),
111 UNIQUE KEY `くくく` (`くくく`),
112 KEY `かかか` (`かか`)
113 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
114 ALTER TABLE `あああ` DROP INDEX `かかか`;
115 ALTER TABLE `あああ` DROP PRIMARY KEY;
116 ALTER TABLE `あああ` DROP INDEX `くくく`;
117 ALTER TABLE `あああ` DROP `かか`;
118 ALTER TABLE `あああ` DROP `くくく`;
119 ALTER TABLE `あああ` DROP `けけけ`;
120 SELECT * FROM `あああ`;
121 ききき
122 あああああ
123 いいいいい
124 ううううう
125 DESC `あああ`;
126 Field Type Null Key Default Extra
127 ききき char(6) NO NULL
128 SHOW CREATE TABLE `あああ`;
129 Table Create Table
130 あああ CREATE TABLE `あああ` (
131 `ききき` char(6) NOT NULL
132 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
133 ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
134 ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
135 ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
136 ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`);
137 ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`);
138 ALTER TABLE `龖龖龖` ADD UNIQUE (`丅丅丅`);
139 ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1);
140 ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6);
141 SELECT * FROM `龖龖龖`;
142 丄丄 丂丂丂 丅丅丅 乚乚乚
143 NULL 丂丂丂丂丂 NULL NULL
144 NULL 丄丄丄丄丄 NULL NULL
145 NULL 丅丅丅丅丅 NULL NULL
146 DESC `龖龖龖`;
147 Field Type Null Key Default Extra
148 丄丄 char(1) YES MUL NULL
149 丂丂丂 char(6) NO PRI NULL
150 丅丅丅 char(1) YES UNI NULL
151 乚乚乚 char(1) YES NULL
152 SHOW CREATE TABLE `龖龖龖`;
153 Table Create Table
154 龖龖龖 CREATE TABLE `龖龖龖` (
155 `丄丄` char(1) DEFAULT NULL,
156 `丂丂丂` char(6) NOT NULL,
157 `丅丅丅` char(1) DEFAULT NULL,
158 `乚乚乚` char(1) DEFAULT NULL,
159 PRIMARY KEY (`丂丂丂`),
160 UNIQUE KEY `丅丅丅` (`丅丅丅`),
161 KEY `丄丄丄` (`丄丄`)
162 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
163 ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
164 ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
165 ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
166 ALTER TABLE `龖龖龖` DROP `丄丄`;
167 ALTER TABLE `龖龖龖` DROP `丅丅丅`;
168 ALTER TABLE `龖龖龖` DROP `乚乚乚`;
169 SELECT * FROM `龖龖龖`;
170 丂丂丂
171 丂丂丂丂丂
172 丄丄丄丄丄
173 丅丅丅丅丅
174 DESC `龖龖龖`;
175 Field Type Null Key Default Extra
176 丂丂丂 char(6) NO NULL
177 SHOW CREATE TABLE `龖龖龖`;
178 Table Create Table
179 龖龖龖 CREATE TABLE `龖龖龖` (
180 `丂丂丂` char(6) NOT NULL
181 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
182 DROP TABLE `アアア`;
183 DROP TABLE `イイイ`;
184 DROP TABLE `あああ`;
185 DROP TABLE `いいい`;
186 DROP TABLE `龖龖龖`;
187 DROP TABLE `龗龗龗`;
188 CREATE TABLE `アアア`(`キキキ` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
189 Warnings:
190 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
191 CREATE TABLE `イイイ`(`ケケケ` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
192 Warnings:
193 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
194 CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
195 Warnings:
196 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
197 CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
198 Warnings:
199 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
200 CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
201 Warnings:
202 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
203 CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
204 Warnings:
205 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
206 INSERT INTO `アアア` VALUES ('アアアアア'),('イイイイイ'),('ウウウウウ');
207 INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
208 INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
209 ALTER TABLE `アアア` ADD `カカカ` char(1) FIRST;
210 ALTER TABLE `アアア` ADD `ククク` char(1) AFTER `キキキ`;
211 ALTER TABLE `アアア` ADD `ケケケ` char(1);
212 ALTER TABLE `アアア` ADD INDEX (`カカカ`);
213 ALTER TABLE `アアア` ADD PRIMARY KEY (`キキキ`);
214 ALTER TABLE `アアア` ADD UNIQUE (`ククク`);
215 ALTER TABLE `アアア` CHANGE `カカカ` `カカ` char(1);
216 ALTER TABLE `アアア` MODIFY `キキキ` char(6);
217 SELECT * FROM `アアア`;
218 カカ キキキ ククク ケケケ
219 NULL アアアアア NULL NULL
220 NULL イイイイイ NULL NULL
221 NULL ウウウウウ NULL NULL
222 DESC `アアア`;
223 Field Type Null Key Default Extra
224 カカ char(1) YES MUL NULL
225 キキキ char(6) NO PRI NULL
226 ククク char(1) YES UNI NULL
227 ケケケ char(1) YES NULL
228 SHOW CREATE TABLE `アアア`;
229 Table Create Table
230 アアア CREATE TABLE `アアア` (
231 `カカ` char(1) DEFAULT NULL,
232 `キキキ` char(6) NOT NULL,
233 `ククク` char(1) DEFAULT NULL,
234 `ケケケ` char(1) DEFAULT NULL,
235 PRIMARY KEY (`キキキ`),
236 UNIQUE KEY `ククク` (`ククク`),
237 KEY `カカカ` (`カカ`)
238 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3
239 ALTER TABLE `アアア` DROP INDEX `カカカ`;
240 ALTER TABLE `アアア` DROP PRIMARY KEY;
241 ALTER TABLE `アアア` DROP INDEX `ククク`;
242 ALTER TABLE `アアア` DROP `カカ`;
243 ALTER TABLE `アアア` DROP `ククク`;
244 ALTER TABLE `アアア` DROP `ケケケ`;
245 SELECT * FROM `アアア`;
246 キキキ
247 アアアアア
248 イイイイイ
249 ウウウウウ
250 DESC `アアア`;
251 Field Type Null Key Default Extra
252 キキキ char(6) NO NULL
253 SHOW CREATE TABLE `アアア`;
254 Table Create Table
255 アアア CREATE TABLE `アアア` (
256 `キキキ` char(6) NOT NULL
257 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3
258 ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
259 ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
260 ALTER TABLE `あああ` ADD `けけけ` char(1);
261 ALTER TABLE `あああ` ADD INDEX (`かかか`);
262 ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
263 ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
264 ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
265 ALTER TABLE `あああ` MODIFY `ききき` char(6);
266 SELECT * FROM `あああ`;
267 かか ききき くくく けけけ
268 NULL あああああ NULL NULL
269 NULL いいいいい NULL NULL
270 NULL ううううう NULL NULL
271 DESC `あああ`;
272 Field Type Null Key Default Extra
273 かか char(1) YES MUL NULL
274 ききき char(6) NO PRI NULL
275 くくく char(1) YES UNI NULL
276 けけけ char(1) YES NULL
277 SHOW CREATE TABLE `あああ`;
278 Table Create Table
279 あああ CREATE TABLE `あああ` (
280 `かか` char(1) DEFAULT NULL,
281 `ききき` char(6) NOT NULL,
282 `くくく` char(1) DEFAULT NULL,
283 `けけけ` char(1) DEFAULT NULL,
284 PRIMARY KEY (`ききき`),
285 UNIQUE KEY `くくく` (`くくく`),
286 KEY `かかか` (`かか`)
287 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3
288 ALTER TABLE `あああ` DROP INDEX `かかか`;
289 ALTER TABLE `あああ` DROP PRIMARY KEY;
290 ALTER TABLE `あああ` DROP INDEX `くくく`;
291 ALTER TABLE `あああ` DROP `かか`;
292 ALTER TABLE `あああ` DROP `くくく`;
293 ALTER TABLE `あああ` DROP `けけけ`;
294 SELECT * FROM `あああ`;
295 ききき
296 あああああ
297 いいいいい
298 ううううう
299 DESC `あああ`;
300 Field Type Null Key Default Extra
301 ききき char(6) NO NULL
302 SHOW CREATE TABLE `あああ`;
303 Table Create Table
304 あああ CREATE TABLE `あああ` (
305 `ききき` char(6) NOT NULL
306 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3
307 ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
308 ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
309 ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
310 ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`);
311 ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`);
312 ALTER TABLE `龖龖龖` ADD UNIQUE (`丅丅丅`);
313 ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1);
314 ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6);
315 SELECT * FROM `龖龖龖`;
316 丄丄 丂丂丂 丅丅丅 乚乚乚
317 NULL 丂丂丂丂丂 NULL NULL
318 NULL 丄丄丄丄丄 NULL NULL
319 NULL 丅丅丅丅丅 NULL NULL
320 DESC `龖龖龖`;
321 Field Type Null Key Default Extra
322 丄丄 char(1) YES MUL NULL
323 丂丂丂 char(6) NO PRI NULL
324 丅丅丅 char(1) YES UNI NULL
325 乚乚乚 char(1) YES NULL
326 SHOW CREATE TABLE `龖龖龖`;
327 Table Create Table
328 龖龖龖 CREATE TABLE `龖龖龖` (
329 `丄丄` char(1) DEFAULT NULL,
330 `丂丂丂` char(6) NOT NULL,
331 `丅丅丅` char(1) DEFAULT NULL,
332 `乚乚乚` char(1) DEFAULT NULL,
333 PRIMARY KEY (`丂丂丂`),
334 UNIQUE KEY `丅丅丅` (`丅丅丅`),
335 KEY `丄丄丄` (`丄丄`)
336 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3
337 ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
338 ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
339 ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
340 ALTER TABLE `龖龖龖` DROP `丄丄`;
341 ALTER TABLE `龖龖龖` DROP `丅丅丅`;
342 ALTER TABLE `龖龖龖` DROP `乚乚乚`;
343 SELECT * FROM `龖龖龖`;
344 丂丂丂
345 丂丂丂丂丂
346 丄丄丄丄丄
347 丅丅丅丅丅
348 DESC `龖龖龖`;
349 Field Type Null Key Default Extra
350 丂丂丂 char(6) NO NULL
351 SHOW CREATE TABLE `龖龖龖`;
352 Table Create Table
353 龖龖龖 CREATE TABLE `龖龖龖` (
354 `丂丂丂` char(6) NOT NULL
355 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3
356 DROP TABLE `アアア`;
357 DROP TABLE `イイイ`;
358 DROP TABLE `あああ`;
359 DROP TABLE `いいい`;
360 DROP TABLE `龖龖龖`;
361 DROP TABLE `龗龗龗`;
362 CREATE TABLE `アアア`(`キキキ` char(5)) DEFAULT CHARSET = utf8 engine=MEMORY;
363 Warnings:
364 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
365 CREATE TABLE `イイイ`(`ケケケ` char(5)) DEFAULT CHARSET = utf8 engine=MEMORY;
366 Warnings:
367 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
368 CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = utf8 engine=MEMORY;
369 Warnings:
370 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
371 CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = utf8 engine=MEMORY;
372 Warnings:
373 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
374 CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = utf8 engine=MEMORY;
375 Warnings:
376 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
377 CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = utf8 engine=MEMORY;
378 Warnings:
379 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
380 INSERT INTO `アアア` VALUES ('アアアアア'),('イイイイイ'),('ウウウウウ');
381 INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
382 INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
383 ALTER TABLE `アアア` ADD `カカカ` char(1) FIRST;
384 ALTER TABLE `アアア` ADD `ククク` char(1) AFTER `キキキ`;
385 ALTER TABLE `アアア` ADD `ケケケ` char(1);
386 ALTER TABLE `アアア` ADD INDEX (`カカカ`);
387 ALTER TABLE `アアア` ADD PRIMARY KEY (`キキキ`);
388 ALTER TABLE `アアア` ADD UNIQUE (`ククク`);
389 ALTER TABLE `アアア` CHANGE `カカカ` `カカ` char(1);
390 ALTER TABLE `アアア` MODIFY `キキキ` char(6);
391 SELECT * FROM `アアア`;
392 カカ キキキ ククク ケケケ
393 NULL アアアアア NULL NULL
394 NULL イイイイイ NULL NULL
395 NULL ウウウウウ NULL NULL
396 DESC `アアア`;
397 Field Type Null Key Default Extra
398 カカ char(1) YES MUL NULL
399 キキキ char(6) NO PRI NULL
400 ククク char(1) YES UNI NULL
401 ケケケ char(1) YES NULL
402 SHOW CREATE TABLE `アアア`;
403 Table Create Table
404 アアア CREATE TABLE `アアア` (
405 `カカ` char(1) DEFAULT NULL,
406 `キキキ` char(6) NOT NULL,
407 `ククク` char(1) DEFAULT NULL,
408 `ケケケ` char(1) DEFAULT NULL,
409 PRIMARY KEY (`キキキ`),
410 UNIQUE KEY `ククク` (`ククク`),
411 KEY `カカカ` (`カカ`)
412 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
413 ALTER TABLE `アアア` DROP INDEX `カカカ`;
414 ALTER TABLE `アアア` DROP PRIMARY KEY;
415 ALTER TABLE `アアア` DROP INDEX `ククク`;
416 ALTER TABLE `アアア` DROP `カカ`;
417 ALTER TABLE `アアア` DROP `ククク`;
418 ALTER TABLE `アアア` DROP `ケケケ`;
419 SELECT * FROM `アアア`;
420 キキキ
421 アアアアア
422 イイイイイ
423 ウウウウウ
424 DESC `アアア`;
425 Field Type Null Key Default Extra
426 キキキ char(6) NO NULL
427 SHOW CREATE TABLE `アアア`;
428 Table Create Table
429 アアア CREATE TABLE `アアア` (
430 `キキキ` char(6) NOT NULL
431 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
432 ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
433 ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
434 ALTER TABLE `あああ` ADD `けけけ` char(1);
435 ALTER TABLE `あああ` ADD INDEX (`かかか`);
436 ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
437 ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
438 ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
439 ALTER TABLE `あああ` MODIFY `ききき` char(6);
440 SELECT * FROM `あああ`;
441 かか ききき くくく けけけ
442 NULL あああああ NULL NULL
443 NULL いいいいい NULL NULL
444 NULL ううううう NULL NULL
445 DESC `あああ`;
446 Field Type Null Key Default Extra
447 かか char(1) YES MUL NULL
448 ききき char(6) NO PRI NULL
449 くくく char(1) YES UNI NULL
450 けけけ char(1) YES NULL
451 SHOW CREATE TABLE `あああ`;
452 Table Create Table
453 あああ CREATE TABLE `あああ` (
454 `かか` char(1) DEFAULT NULL,
455 `ききき` char(6) NOT NULL,
456 `くくく` char(1) DEFAULT NULL,
457 `けけけ` char(1) DEFAULT NULL,
458 PRIMARY KEY (`ききき`),
459 UNIQUE KEY `くくく` (`くくく`),
460 KEY `かかか` (`かか`)
461 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
462 ALTER TABLE `あああ` DROP INDEX `かかか`;
463 ALTER TABLE `あああ` DROP PRIMARY KEY;
464 ALTER TABLE `あああ` DROP INDEX `くくく`;
465 ALTER TABLE `あああ` DROP `かか`;
466 ALTER TABLE `あああ` DROP `くくく`;
467 ALTER TABLE `あああ` DROP `けけけ`;
468 SELECT * FROM `あああ`;
469 ききき
470 あああああ
471 いいいいい
472 ううううう
473 DESC `あああ`;
474 Field Type Null Key Default Extra
475 ききき char(6) NO NULL
476 SHOW CREATE TABLE `あああ`;
477 Table Create Table
478 あああ CREATE TABLE `あああ` (
479 `ききき` char(6) NOT NULL
480 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
481 ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
482 ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
483 ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
484 ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`);
485 ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`);
486 ALTER TABLE `龖龖龖` ADD UNIQUE (`丅丅丅`);
487 ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1);
488 ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6);
489 SELECT * FROM `龖龖龖`;
490 丄丄 丂丂丂 丅丅丅 乚乚乚
491 NULL 丂丂丂丂丂 NULL NULL
492 NULL 丄丄丄丄丄 NULL NULL
493 NULL 丅丅丅丅丅 NULL NULL
494 DESC `龖龖龖`;
495 Field Type Null Key Default Extra
496 丄丄 char(1) YES MUL NULL
497 丂丂丂 char(6) NO PRI NULL
498 丅丅丅 char(1) YES UNI NULL
499 乚乚乚 char(1) YES NULL
500 SHOW CREATE TABLE `龖龖龖`;
501 Table Create Table
502 龖龖龖 CREATE TABLE `龖龖龖` (
503 `丄丄` char(1) DEFAULT NULL,
504 `丂丂丂` char(6) NOT NULL,
505 `丅丅丅` char(1) DEFAULT NULL,
506 `乚乚乚` char(1) DEFAULT NULL,
507 PRIMARY KEY (`丂丂丂`),
508 UNIQUE KEY `丅丅丅` (`丅丅丅`),
509 KEY `丄丄丄` (`丄丄`)
510 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
511 ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
512 ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
513 ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
514 ALTER TABLE `龖龖龖` DROP `丄丄`;
515 ALTER TABLE `龖龖龖` DROP `丅丅丅`;
516 ALTER TABLE `龖龖龖` DROP `乚乚乚`;
517 SELECT * FROM `龖龖龖`;
518 丂丂丂
519 丂丂丂丂丂
520 丄丄丄丄丄
521 丅丅丅丅丅
522 DESC `龖龖龖`;
523 Field Type Null Key Default Extra
524 丂丂丂 char(6) NO NULL
525 SHOW CREATE TABLE `龖龖龖`;
526 Table Create Table
527 龖龖龖 CREATE TABLE `龖龖龖` (
528 `丂丂丂` char(6) NOT NULL
529 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
530 DROP TABLE `アアア`;
531 DROP TABLE `イイイ`;
532 DROP TABLE `あああ`;
533 DROP TABLE `いいい`;
534 DROP TABLE `龖龖龖`;
535 DROP TABLE `龗龗龗`;