2 SET character_set_database = sjis;
3 DROP TABLE IF EXISTS `±±±`;
4 DROP TABLE IF EXISTS `²²²`;
5 DROP TABLE IF EXISTS `‚ ‚ ‚ `;
6 DROP TABLE IF EXISTS `‚¢‚¢‚¢`;
7 DROP TABLE IF EXISTS `ƒ\ƒ\ƒ\`;
8 DROP TABLE IF EXISTS `�\�\�\`;
9 CREATE TABLE `±±±`(`···` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
10 CREATE TABLE `²²²`(`¹¹¹` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
11 CREATE TABLE `‚ ‚ ‚ `(`‚«‚«‚«` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
12 CREATE TABLE `‚¢‚¢‚¢`(`‚¯‚¯‚¯` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
13 CREATE TABLE `ƒ\ƒ\ƒ\`(`•\•\•\` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
14 CREATE TABLE `�\�\�\`(`—\—\—\` char(5)) DEFAULT CHARSET = sjis 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=sjis
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=sjis
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);
75 SELECT * FROM `‚ ‚ ‚ `;
76 ‚©‚© ‚«‚«‚« ‚‚‚ ‚¯‚¯‚¯
77 NULL ‚ ‚ ‚ ‚ ‚ NULL NULL
78 NULL ‚¢‚¢‚¢‚¢‚¢ NULL NULL
79 NULL ‚¤‚¤‚¤‚¤‚¤ NULL NULL
81 Field Type Null Key Default Extra
82 ‚©‚© char(1) YES MUL NULL
84 ‚‚‚ char(1) YES UNI NULL
85 ‚¯‚¯‚¯ char(1) YES 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,
93 PRIMARY KEY (`‚«‚«‚«`),
94 UNIQUE KEY `‚‚‚` (`‚‚‚`),
96 ) ENGINE=InnoDB DEFAULT CHARSET=sjis
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 `‚¯‚¯‚¯`;
103 SELECT * FROM `‚ ‚ ‚ `;
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=sjis
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);
124 SELECT * FROM `ƒ\ƒ\ƒ\`;
125 �\�\ •\•\•\ ”\”\”\ —\—\—\
126 NULL �\�\�\�\�\ NULL NULL
127 NULL ”\”\”\”\”\ NULL NULL
128 NULL •\•\•\•\•\ NULL NULL
130 Field Type Null Key Default Extra
131 �\�\ char(1) YES MUL NULL
132 •\•\•\ char(6) NO PRI
133 ”\”\”\ char(1) YES UNI NULL
134 —\—\—\ char(1) YES 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,
142 PRIMARY KEY (`•\•\•\`),
143 UNIQUE KEY `”\”\”\` (`”\”\”\`),
144 KEY `�\�\�\` (`�\�\`)
145 ) ENGINE=InnoDB DEFAULT CHARSET=sjis
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 `—\—\—\`;
152 SELECT * FROM `ƒ\ƒ\ƒ\`;
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=sjis
171 CREATE TABLE `±±±`(`···` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
172 CREATE TABLE `²²²`(`¹¹¹` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
173 CREATE TABLE `‚ ‚ ‚ `(`‚«‚«‚«` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
174 CREATE TABLE `‚¢‚¢‚¢`(`‚¯‚¯‚¯` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
175 CREATE TABLE `ƒ\ƒ\ƒ\`(`•\•\•\` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
176 CREATE TABLE `�\�\�\`(`—\—\—\` char(5)) DEFAULT CHARSET = sjis 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=sjis
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=sjis
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);
237 SELECT * FROM `‚ ‚ ‚ `;
238 ‚©‚© ‚«‚«‚« ‚‚‚ ‚¯‚¯‚¯
239 NULL ‚ ‚ ‚ ‚ ‚ NULL NULL
240 NULL ‚¢‚¢‚¢‚¢‚¢ NULL NULL
241 NULL ‚¤‚¤‚¤‚¤‚¤ NULL NULL
243 Field Type Null Key Default Extra
244 ‚©‚© char(1) YES MUL NULL
245 ‚«‚«‚« char(6) NO PRI
246 ‚‚‚ char(1) YES UNI NULL
247 ‚¯‚¯‚¯ char(1) YES 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,
255 PRIMARY KEY (`‚«‚«‚«`),
256 UNIQUE KEY `‚‚‚` (`‚‚‚`),
257 KEY `‚©‚©‚©` (`‚©‚©`)
258 ) ENGINE=MyISAM DEFAULT CHARSET=sjis
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 `‚¯‚¯‚¯`;
265 SELECT * FROM `‚ ‚ ‚ `;
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=sjis
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);
286 SELECT * FROM `ƒ\ƒ\ƒ\`;
287 �\�\ •\•\•\ ”\”\”\ —\—\—\
288 NULL •\•\•\•\•\ NULL NULL
289 NULL �\�\�\�\�\ NULL NULL
290 NULL ”\”\”\”\”\ NULL NULL
292 Field Type Null Key Default Extra
293 �\�\ char(1) YES MUL NULL
294 •\•\•\ char(6) NO PRI
295 ”\”\”\ char(1) YES UNI NULL
296 —\—\—\ char(1) YES 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,
304 PRIMARY KEY (`•\•\•\`),
305 UNIQUE KEY `”\”\”\` (`”\”\”\`),
306 KEY `�\�\�\` (`�\�\`)
307 ) ENGINE=MyISAM DEFAULT CHARSET=sjis
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 `—\—\—\`;
314 SELECT * FROM `ƒ\ƒ\ƒ\`;
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=sjis
333 CREATE TABLE `±±±`(`···` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
334 CREATE TABLE `²²²`(`¹¹¹` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
335 CREATE TABLE `‚ ‚ ‚ `(`‚«‚«‚«` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
336 CREATE TABLE `‚¢‚¢‚¢`(`‚¯‚¯‚¯` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
337 CREATE TABLE `ƒ\ƒ\ƒ\`(`•\•\•\` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
338 CREATE TABLE `�\�\�\`(`—\—\—\` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
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=sjis
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=sjis
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);
399 SELECT * FROM `‚ ‚ ‚ `;
400 ‚©‚© ‚«‚«‚« ‚‚‚ ‚¯‚¯‚¯
401 NULL ‚ ‚ ‚ ‚ ‚ NULL NULL
402 NULL ‚¢‚¢‚¢‚¢‚¢ NULL NULL
403 NULL ‚¤‚¤‚¤‚¤‚¤ NULL NULL
405 Field Type Null Key Default Extra
406 ‚©‚© char(1) YES MUL NULL
407 ‚«‚«‚« char(6) NO PRI
408 ‚‚‚ char(1) YES UNI NULL
409 ‚¯‚¯‚¯ char(1) YES 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,
417 PRIMARY KEY (`‚«‚«‚«`),
418 UNIQUE KEY `‚‚‚` (`‚‚‚`),
419 KEY `‚©‚©‚©` (`‚©‚©`)
420 ) ENGINE=MEMORY DEFAULT CHARSET=sjis
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 `‚¯‚¯‚¯`;
427 SELECT * FROM `‚ ‚ ‚ `;
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=sjis
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);
448 SELECT * FROM `ƒ\ƒ\ƒ\`;
449 �\�\ •\•\•\ ”\”\”\ —\—\—\
450 NULL •\•\•\•\•\ NULL NULL
451 NULL �\�\�\�\�\ NULL NULL
452 NULL ”\”\”\”\”\ NULL NULL
454 Field Type Null Key Default Extra
455 �\�\ char(1) YES MUL NULL
456 •\•\•\ char(6) NO PRI
457 ”\”\”\ char(1) YES UNI NULL
458 —\—\—\ char(1) YES 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,
466 PRIMARY KEY (`•\•\•\`),
467 UNIQUE KEY `”\”\”\` (`”\”\”\`),
468 KEY `�\�\�\` (`�\�\`)
469 ) ENGINE=MEMORY DEFAULT CHARSET=sjis
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 `—\—\—\`;
476 SELECT * FROM `ƒ\ƒ\ƒ\`;
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=sjis