diff options
Diffstat (limited to 'mysql-test/suite/jp/r/jp_alter_ujis.result')
| -rw-r--r-- | mysql-test/suite/jp/r/jp_alter_ujis.result | 339 |
1 files changed, 93 insertions, 246 deletions
diff --git a/mysql-test/suite/jp/r/jp_alter_ujis.result b/mysql-test/suite/jp/r/jp_alter_ujis.result index afa3c79cbce..7e4f19342f6 100644 --- a/mysql-test/suite/jp/r/jp_alter_ujis.result +++ b/mysql-test/suite/jp/r/jp_alter_ujis.result @@ -31,17 +31,17 @@ NULL ｳｳｳｳｳ NULL NULL DESC `ｱｱｱ`; Field Type Null Key Default Extra ｶｶ char(1) YES MUL NULL -ｷｷｷ char(6) PRI -ｸｸｸ char(1) YES MUL NULL +ｷｷｷ char(6) NO PRI +ｸｸｸ char(1) YES UNI NULL ｹｹｹ char(1) YES NULL SHOW CREATE TABLE `ｱｱｱ`; Table Create Table ｱｱｱ CREATE TABLE `ｱｱｱ` ( - `ｶｶ` char(1) default NULL, - `ｷｷｷ` char(6) NOT NULL default '', - `ｸｸｸ` char(1) default NULL, - `ｹｹｹ` char(1) default NULL, - PRIMARY KEY (`ｷｷｷ`), + `ｶｶ` char(1) DEFAULT NULL, + `ｷｷｷ` char(6) NOT NULL DEFAULT '', + `ｸｸｸ` char(1) DEFAULT NULL, + `ｹｹｹ` char(1) DEFAULT NULL, + PRIMARY KEY (`ｷｷｷ`), UNIQUE KEY `ｸｸｸ` (`ｸｸｸ`), KEY `ｶｶｶ` (`ｶｶ`) ) ENGINE=InnoDB DEFAULT CHARSET=ujis @@ -58,11 +58,11 @@ SELECT * FROM `ｱｱｱ`; ｳｳｳｳｳ DESC `ｱｱｱ`; Field Type Null Key Default Extra -ｷｷｷ char(6) +ｷｷｷ char(6) NO SHOW CREATE TABLE `ｱｱｱ`; Table Create Table ｱｱｱ CREATE TABLE `ｱｱｱ` ( - `ｷｷｷ` char(6) NOT NULL default '' + `ｷｷｷ` char(6) NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=ujis ALTER TABLE `あああ` ADD `かかか` char(1) FIRST; ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`; @@ -80,17 +80,17 @@ NULL ううううう NULL NULL DESC `あああ`; Field Type Null Key Default Extra かか char(1) YES MUL NULL -ききき char(6) PRI -くくく char(1) YES MUL NULL +ききき char(6) NO PRI +くくく char(1) YES UNI NULL けけけ char(1) YES NULL SHOW CREATE TABLE `あああ`; Table Create Table あああ CREATE TABLE `あああ` ( - `かか` char(1) default NULL, - `ききき` char(6) NOT NULL default '', - `くくく` char(1) default NULL, - `けけけ` char(1) default NULL, - PRIMARY KEY (`ききき`), + `かか` char(1) DEFAULT NULL, + `ききき` char(6) NOT NULL DEFAULT '', + `くくく` char(1) DEFAULT NULL, + `けけけ` char(1) DEFAULT NULL, + PRIMARY KEY (`ききき`), UNIQUE KEY `くくく` (`くくく`), KEY `かかか` (`かか`) ) ENGINE=InnoDB DEFAULT CHARSET=ujis @@ -107,11 +107,11 @@ SELECT * FROM `あああ`; ううううう DESC `あああ`; Field Type Null Key Default Extra -ききき char(6) +ききき char(6) NO SHOW CREATE TABLE `あああ`; Table Create Table あああ CREATE TABLE `あああ` ( - `ききき` char(6) NOT NULL default '' + `ききき` char(6) NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=ujis ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST; ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`; @@ -129,17 +129,17 @@ NULL 丅丅丅丅丅 NULL NULL DESC `龖龖龖`; Field Type Null Key Default Extra 丄丄 char(1) YES MUL NULL -丂丂丂 char(6) PRI -丅丅丅 char(1) YES MUL NULL +丂丂丂 char(6) NO PRI +丅丅丅 char(1) YES UNI NULL 乚乚乚 char(1) YES NULL SHOW CREATE TABLE `龖龖龖`; Table Create Table 龖龖龖 CREATE TABLE `龖龖龖` ( - `丄丄` char(1) default NULL, - `丂丂丂` char(6) NOT NULL default '', - `丅丅丅` char(1) default NULL, - `乚乚乚` char(1) default NULL, - PRIMARY KEY (`丂丂丂`), + `丄丄` char(1) DEFAULT NULL, + `丂丂丂` char(6) NOT NULL DEFAULT '', + `丅丅丅` char(1) DEFAULT NULL, + `乚乚乚` char(1) DEFAULT NULL, + PRIMARY KEY (`丂丂丂`), UNIQUE KEY `丅丅丅` (`丅丅丅`), KEY `丄丄丄` (`丄丄`) ) ENGINE=InnoDB DEFAULT CHARSET=ujis @@ -156,11 +156,11 @@ SELECT * FROM `龖龖龖`; 丅丅丅丅丅 DESC `龖龖龖`; Field Type Null Key Default Extra -丂丂丂 char(6) +丂丂丂 char(6) NO SHOW CREATE TABLE `龖龖龖`; Table Create Table 龖龖龖 CREATE TABLE `龖龖龖` ( - `丂丂丂` char(6) NOT NULL default '' + `丂丂丂` char(6) NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=ujis DROP TABLE `ｱｱｱ`; DROP TABLE `ｲｲｲ`; @@ -193,17 +193,17 @@ NULL ｳｳｳｳｳ NULL NULL DESC `ｱｱｱ`; Field Type Null Key Default Extra ｶｶ char(1) YES MUL NULL -ｷｷｷ char(6) PRI -ｸｸｸ char(1) YES MUL NULL +ｷｷｷ char(6) NO PRI +ｸｸｸ char(1) YES UNI NULL ｹｹｹ char(1) YES NULL SHOW CREATE TABLE `ｱｱｱ`; Table Create Table ｱｱｱ CREATE TABLE `ｱｱｱ` ( - `ｶｶ` char(1) default NULL, - `ｷｷｷ` char(6) NOT NULL default '', - `ｸｸｸ` char(1) default NULL, - `ｹｹｹ` char(1) default NULL, - PRIMARY KEY (`ｷｷｷ`), + `ｶｶ` char(1) DEFAULT NULL, + `ｷｷｷ` char(6) NOT NULL DEFAULT '', + `ｸｸｸ` char(1) DEFAULT NULL, + `ｹｹｹ` char(1) DEFAULT NULL, + PRIMARY KEY (`ｷｷｷ`), UNIQUE KEY `ｸｸｸ` (`ｸｸｸ`), KEY `ｶｶｶ` (`ｶｶ`) ) ENGINE=MyISAM DEFAULT CHARSET=ujis @@ -220,11 +220,11 @@ SELECT * FROM `ｱｱｱ`; ｳｳｳｳｳ DESC `ｱｱｱ`; Field Type Null Key Default Extra -ｷｷｷ char(6) +ｷｷｷ char(6) NO SHOW CREATE TABLE `ｱｱｱ`; Table Create Table ｱｱｱ CREATE TABLE `ｱｱｱ` ( - `ｷｷｷ` char(6) NOT NULL default '' + `ｷｷｷ` char(6) NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=ujis ALTER TABLE `あああ` ADD `かかか` char(1) FIRST; ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`; @@ -242,17 +242,17 @@ NULL ううううう NULL NULL DESC `あああ`; Field Type Null Key Default Extra かか char(1) YES MUL NULL -ききき char(6) PRI -くくく char(1) YES MUL NULL +ききき char(6) NO PRI +くくく char(1) YES UNI NULL けけけ char(1) YES NULL SHOW CREATE TABLE `あああ`; Table Create Table あああ CREATE TABLE `あああ` ( - `かか` char(1) default NULL, - `ききき` char(6) NOT NULL default '', - `くくく` char(1) default NULL, - `けけけ` char(1) default NULL, - PRIMARY KEY (`ききき`), + `かか` char(1) DEFAULT NULL, + `ききき` char(6) NOT NULL DEFAULT '', + `くくく` char(1) DEFAULT NULL, + `けけけ` char(1) DEFAULT NULL, + PRIMARY KEY (`ききき`), UNIQUE KEY `くくく` (`くくく`), KEY `かかか` (`かか`) ) ENGINE=MyISAM DEFAULT CHARSET=ujis @@ -269,11 +269,11 @@ SELECT * FROM `あああ`; ううううう DESC `あああ`; Field Type Null Key Default Extra -ききき char(6) +ききき char(6) NO SHOW CREATE TABLE `あああ`; Table Create Table あああ CREATE TABLE `あああ` ( - `ききき` char(6) NOT NULL default '' + `ききき` char(6) NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=ujis ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST; ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`; @@ -291,17 +291,17 @@ NULL 丅丅丅丅丅 NULL NULL DESC `龖龖龖`; Field Type Null Key Default Extra 丄丄 char(1) YES MUL NULL -丂丂丂 char(6) PRI -丅丅丅 char(1) YES MUL NULL +丂丂丂 char(6) NO PRI +丅丅丅 char(1) YES UNI NULL 乚乚乚 char(1) YES NULL SHOW CREATE TABLE `龖龖龖`; Table Create Table 龖龖龖 CREATE TABLE `龖龖龖` ( - `丄丄` char(1) default NULL, - `丂丂丂` char(6) NOT NULL default '', - `丅丅丅` char(1) default NULL, - `乚乚乚` char(1) default NULL, - PRIMARY KEY (`丂丂丂`), + `丄丄` char(1) DEFAULT NULL, + `丂丂丂` char(6) NOT NULL DEFAULT '', + `丅丅丅` char(1) DEFAULT NULL, + `乚乚乚` char(1) DEFAULT NULL, + PRIMARY KEY (`丂丂丂`), UNIQUE KEY `丅丅丅` (`丅丅丅`), KEY `丄丄丄` (`丄丄`) ) ENGINE=MyISAM DEFAULT CHARSET=ujis @@ -318,11 +318,11 @@ SELECT * FROM `龖龖龖`; 丅丅丅丅丅 DESC `龖龖龖`; Field Type Null Key Default Extra -丂丂丂 char(6) +丂丂丂 char(6) NO SHOW CREATE TABLE `龖龖龖`; Table Create Table 龖龖龖 CREATE TABLE `龖龖龖` ( - `丂丂丂` char(6) NOT NULL default '' + `丂丂丂` char(6) NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=ujis DROP TABLE `ｱｱｱ`; DROP TABLE `ｲｲｲ`; @@ -330,12 +330,12 @@ DROP TABLE `あああ`; DROP TABLE `いいい`; DROP TABLE `龖龖龖`; DROP TABLE `龗龗龗`; -CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = ujis engine=HEAP; +CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = ujis engine=MEMORY; INSERT INTO `ｱｱｱ` VALUES ('ｱｱｱｱｱ'),('ｲｲｲｲｲ'),('ｳｳｳｳｳ'); INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう'); INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅'); @@ -355,20 +355,20 @@ NULL ｳｳｳｳｳ NULL NULL DESC `ｱｱｱ`; Field Type Null Key Default Extra ｶｶ char(1) YES MUL NULL -ｷｷｷ char(6) PRI -ｸｸｸ char(1) YES MUL NULL +ｷｷｷ char(6) NO PRI +ｸｸｸ char(1) YES UNI NULL ｹｹｹ char(1) YES NULL SHOW CREATE TABLE `ｱｱｱ`; Table Create Table ｱｱｱ CREATE TABLE `ｱｱｱ` ( - `ｶｶ` char(1) default NULL, - `ｷｷｷ` char(6) NOT NULL default '', - `ｸｸｸ` char(1) default NULL, - `ｹｹｹ` char(1) default NULL, - PRIMARY KEY (`ｷｷｷ`), + `ｶｶ` char(1) DEFAULT NULL, + `ｷｷｷ` char(6) NOT NULL DEFAULT '', + `ｸｸｸ` char(1) DEFAULT NULL, + `ｹｹｹ` char(1) DEFAULT NULL, + PRIMARY KEY (`ｷｷｷ`), UNIQUE KEY `ｸｸｸ` (`ｸｸｸ`), KEY `ｶｶｶ` (`ｶｶ`) -) ENGINE=HEAP DEFAULT CHARSET=ujis +) ENGINE=MEMORY DEFAULT CHARSET=ujis ALTER TABLE `ｱｱｱ` DROP INDEX `ｶｶｶ`; ALTER TABLE `ｱｱｱ` DROP PRIMARY KEY; ALTER TABLE `ｱｱｱ` DROP INDEX `ｸｸｸ`; @@ -382,12 +382,12 @@ SELECT * FROM `ｱｱｱ`; ｳｳｳｳｳ DESC `ｱｱｱ`; Field Type Null Key Default Extra -ｷｷｷ char(6) +ｷｷｷ char(6) NO SHOW CREATE TABLE `ｱｱｱ`; Table Create Table ｱｱｱ CREATE TABLE `ｱｱｱ` ( - `ｷｷｷ` char(6) NOT NULL default '' -) ENGINE=HEAP DEFAULT CHARSET=ujis + `ｷｷｷ` char(6) NOT NULL DEFAULT '' +) ENGINE=MEMORY DEFAULT CHARSET=ujis ALTER TABLE `あああ` ADD `かかか` char(1) FIRST; ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`; ALTER TABLE `あああ` ADD `けけけ` char(1); @@ -404,20 +404,20 @@ NULL ううううう NULL NULL DESC `あああ`; Field Type Null Key Default Extra かか char(1) YES MUL NULL -ききき char(6) PRI -くくく char(1) YES MUL NULL +ききき char(6) NO PRI +くくく char(1) YES UNI NULL けけけ char(1) YES NULL SHOW CREATE TABLE `あああ`; Table Create Table あああ CREATE TABLE `あああ` ( - `かか` char(1) default NULL, - `ききき` char(6) NOT NULL default '', - `くくく` char(1) default NULL, - `けけけ` char(1) default NULL, - PRIMARY KEY (`ききき`), + `かか` char(1) DEFAULT NULL, + `ききき` char(6) NOT NULL DEFAULT '', + `くくく` char(1) DEFAULT NULL, + `けけけ` char(1) DEFAULT NULL, + PRIMARY KEY (`ききき`), UNIQUE KEY `くくく` (`くくく`), KEY `かかか` (`かか`) -) ENGINE=HEAP DEFAULT CHARSET=ujis +) ENGINE=MEMORY DEFAULT CHARSET=ujis ALTER TABLE `あああ` DROP INDEX `かかか`; ALTER TABLE `あああ` DROP PRIMARY KEY; ALTER TABLE `あああ` DROP INDEX `くくく`; @@ -431,12 +431,12 @@ SELECT * FROM `あああ`; ううううう DESC `あああ`; Field Type Null Key Default Extra -ききき char(6) +ききき char(6) NO SHOW CREATE TABLE `あああ`; Table Create Table あああ CREATE TABLE `あああ` ( - `ききき` char(6) NOT NULL default '' -) ENGINE=HEAP DEFAULT CHARSET=ujis + `ききき` char(6) NOT NULL DEFAULT '' +) ENGINE=MEMORY DEFAULT CHARSET=ujis ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST; ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`; ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1); @@ -453,20 +453,20 @@ NULL 丅丅丅丅丅 NULL NULL DESC `龖龖龖`; Field Type Null Key Default Extra 丄丄 char(1) YES MUL NULL -丂丂丂 char(6) PRI -丅丅丅 char(1) YES MUL NULL +丂丂丂 char(6) NO PRI +丅丅丅 char(1) YES UNI NULL 乚乚乚 char(1) YES NULL SHOW CREATE TABLE `龖龖龖`; Table Create Table 龖龖龖 CREATE TABLE `龖龖龖` ( - `丄丄` char(1) default NULL, - `丂丂丂` char(6) NOT NULL default '', - `丅丅丅` char(1) default NULL, - `乚乚乚` char(1) default NULL, - PRIMARY KEY (`丂丂丂`), + `丄丄` char(1) DEFAULT NULL, + `丂丂丂` char(6) NOT NULL DEFAULT '', + `丅丅丅` char(1) DEFAULT NULL, + `乚乚乚` char(1) DEFAULT NULL, + PRIMARY KEY (`丂丂丂`), UNIQUE KEY `丅丅丅` (`丅丅丅`), KEY `丄丄丄` (`丄丄`) -) ENGINE=HEAP DEFAULT CHARSET=ujis +) ENGINE=MEMORY DEFAULT CHARSET=ujis ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`; ALTER TABLE `龖龖龖` DROP PRIMARY KEY; ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`; @@ -480,165 +480,12 @@ SELECT * FROM `龖龖龖`; 丅丅丅丅丅 DESC `龖龖龖`; Field Type Null Key Default Extra -丂丂丂 char(6) +丂丂丂 char(6) NO SHOW CREATE TABLE `龖龖龖`; Table Create Table 龖龖龖 CREATE TABLE `龖龖龖` ( - `丂丂丂` char(6) NOT NULL default '' -) ENGINE=HEAP DEFAULT CHARSET=ujis -DROP TABLE `ｱｱｱ`; -DROP TABLE `ｲｲｲ`; -DROP TABLE `あああ`; -DROP TABLE `いいい`; -DROP TABLE `龖龖龖`; -DROP TABLE `龗龗龗`; -CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = ujis engine=BDB; -INSERT INTO `ｱｱｱ` VALUES ('ｱｱｱｱｱ'),('ｲｲｲｲｲ'),('ｳｳｳｳｳ'); -INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう'); -INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅'); -ALTER TABLE `ｱｱｱ` ADD `ｶｶｶ` char(1) FIRST; -ALTER TABLE `ｱｱｱ` ADD `ｸｸｸ` char(1) AFTER `ｷｷｷ`; -ALTER TABLE `ｱｱｱ` ADD `ｹｹｹ` char(1); -ALTER TABLE `ｱｱｱ` ADD INDEX (`ｶｶｶ`); -ALTER TABLE `ｱｱｱ` ADD PRIMARY KEY (`ｷｷｷ`); -ALTER TABLE `ｱｱｱ` CHANGE `ｶｶｶ` `ｶｶ` char(1); -ALTER TABLE `ｱｱｱ` MODIFY `ｷｷｷ` char(6); -SELECT * FROM `ｱｱｱ`; -ｶｶ ｷｷｷ ｸｸｸ ｹｹｹ -NULL ｱｱｱｱｱ NULL NULL -NULL ｲｲｲｲｲ NULL NULL -NULL ｳｳｳｳｳ NULL NULL -DESC `ｱｱｱ`; -Field Type Null Key Default Extra -ｶｶ char(1) YES MUL NULL -ｷｷｷ char(6) PRI -ｸｸｸ char(1) YES NULL -ｹｹｹ char(1) YES NULL -SHOW CREATE TABLE `ｱｱｱ`; -Table Create Table -ｱｱｱ CREATE TABLE `ｱｱｱ` ( - `ｶｶ` char(1) default NULL, - `ｷｷｷ` char(6) NOT NULL default '', - `ｸｸｸ` char(1) default NULL, - `ｹｹｹ` char(1) default NULL, - PRIMARY KEY (`ｷｷｷ`), - KEY `ｶｶｶ` (`ｶｶ`) -) ENGINE=BerkeleyDB DEFAULT CHARSET=ujis -ALTER TABLE `ｱｱｱ` DROP INDEX `ｶｶｶ`; -ALTER TABLE `ｱｱｱ` DROP PRIMARY KEY; -ALTER TABLE `ｱｱｱ` DROP `ｶｶ`; -ALTER TABLE `ｱｱｱ` DROP `ｸｸｸ`; -ALTER TABLE `ｱｱｱ` DROP `ｹｹｹ`; -SELECT * FROM `ｱｱｱ`; -ｷｷｷ -ｱｱｱｱｱ -ｲｲｲｲｲ -ｳｳｳｳｳ -DESC `ｱｱｱ`; -Field Type Null Key Default Extra -ｷｷｷ char(6) -SHOW CREATE TABLE `ｱｱｱ`; -Table Create Table -ｱｱｱ CREATE TABLE `ｱｱｱ` ( - `ｷｷｷ` char(6) NOT NULL default '' -) ENGINE=BerkeleyDB DEFAULT CHARSET=ujis -ALTER TABLE `あああ` ADD `かかか` char(1) FIRST; -ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`; -ALTER TABLE `あああ` ADD `けけけ` char(1); -ALTER TABLE `あああ` ADD INDEX (`かかか`); -ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`); -ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1); -ALTER TABLE `あああ` MODIFY `ききき` char(6); -SELECT * FROM `あああ`; -かか ききき くくく けけけ -NULL あああああ NULL NULL -NULL いいいいい NULL NULL -NULL ううううう NULL NULL -DESC `あああ`; -Field Type Null Key Default Extra -かか char(1) YES MUL NULL -ききき char(6) PRI -くくく char(1) YES NULL -けけけ char(1) YES NULL -SHOW CREATE TABLE `あああ`; -Table Create Table -あああ CREATE TABLE `あああ` ( - `かか` char(1) default NULL, - `ききき` char(6) NOT NULL default '', - `くくく` char(1) default NULL, - `けけけ` char(1) default NULL, - PRIMARY KEY (`ききき`), - KEY `かかか` (`かか`) -) ENGINE=BerkeleyDB DEFAULT CHARSET=ujis -ALTER TABLE `あああ` DROP INDEX `かかか`; -ALTER TABLE `あああ` DROP PRIMARY KEY; -ALTER TABLE `あああ` DROP `かか`; -ALTER TABLE `あああ` DROP `くくく`; -ALTER TABLE `あああ` DROP `けけけ`; -SELECT * FROM `あああ`; -ききき -あああああ -いいいいい -ううううう -DESC `あああ`; -Field Type Null Key Default Extra -ききき char(6) -SHOW CREATE TABLE `あああ`; -Table Create Table -あああ CREATE TABLE `あああ` ( - `ききき` char(6) NOT NULL default '' -) ENGINE=BerkeleyDB DEFAULT CHARSET=ujis -ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST; -ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`; -ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1); -ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`); -ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`); -ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1); -ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6); -SELECT * FROM `龖龖龖`; -丄丄 丂丂丂 丅丅丅 乚乚乚 -NULL 丂丂丂丂丂 NULL NULL -NULL 丄丄丄丄丄 NULL NULL -NULL 丅丅丅丅丅 NULL NULL -DESC `龖龖龖`; -Field Type Null Key Default Extra -丄丄 char(1) YES MUL NULL -丂丂丂 char(6) PRI -丅丅丅 char(1) YES NULL -乚乚乚 char(1) YES NULL -SHOW CREATE TABLE `龖龖龖`; -Table Create Table -龖龖龖 CREATE TABLE `龖龖龖` ( - `丄丄` char(1) default NULL, - `丂丂丂` char(6) NOT NULL default '', - `丅丅丅` char(1) default NULL, - `乚乚乚` char(1) default NULL, - PRIMARY KEY (`丂丂丂`), - KEY `丄丄丄` (`丄丄`) -) ENGINE=BerkeleyDB DEFAULT CHARSET=ujis -ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`; -ALTER TABLE `龖龖龖` DROP PRIMARY KEY; -ALTER TABLE `龖龖龖` DROP `丄丄`; -ALTER TABLE `龖龖龖` DROP `丅丅丅`; -ALTER TABLE `龖龖龖` DROP `乚乚乚`; -SELECT * FROM `龖龖龖`; -丂丂丂 -丂丂丂丂丂 -丄丄丄丄丄 -丅丅丅丅丅 -DESC `龖龖龖`; -Field Type Null Key Default Extra -丂丂丂 char(6) -SHOW CREATE TABLE `龖龖龖`; -Table Create Table -龖龖龖 CREATE TABLE `龖龖龖` ( - `丂丂丂` char(6) NOT NULL default '' -) ENGINE=BerkeleyDB DEFAULT CHARSET=ujis + `丂丂丂` char(6) NOT NULL DEFAULT '' +) ENGINE=MEMORY DEFAULT CHARSET=ujis DROP TABLE `ｱｱｱ`; DROP TABLE `ｲｲｲ`; DROP TABLE `あああ`; |