summaryrefslogtreecommitdiff
path: root/mysql-test/suite/jp/r/jp_alter_ucs2.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/jp/r/jp_alter_ucs2.result')
-rwxr-xr-xmysql-test/suite/jp/r/jp_alter_ucs2.result648
1 files changed, 648 insertions, 0 deletions
diff --git a/mysql-test/suite/jp/r/jp_alter_ucs2.result b/mysql-test/suite/jp/r/jp_alter_ucs2.result
new file mode 100755
index 00000000000..2756e5a758d
--- /dev/null
+++ b/mysql-test/suite/jp/r/jp_alter_ucs2.result
@@ -0,0 +1,648 @@
+DROP TABLE IF EXISTS `ｱｱｱ`;
+DROP TABLE IF EXISTS `ｲｲｲ`;
+DROP TABLE IF EXISTS `あああ`;
+DROP TABLE IF EXISTS `いいい`;
+DROP TABLE IF EXISTS `龖龖龖`;
+DROP TABLE IF EXISTS `龗龗龗`;
+SET NAMES ujis;
+SET character_set_database = ucs2;
+SET collation_connection = ucs2_general_ci;
+CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = ucs2 engine=INNODB;
+CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = ucs2 engine=INNODB;
+CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = ucs2 engine=INNODB;
+CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = ucs2 engine=INNODB;
+CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = ucs2 engine=INNODB;
+CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = ucs2 engine=INNODB;
+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 `ｱｱｱ` ADD UNIQUE (`ｸｸｸ`);
+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 MUL 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 (`ｷｷｷ`),
+ UNIQUE KEY `ｸｸｸ` (`ｸｸｸ`),
+ KEY `ｶｶｶ` (`ｶｶ`)
+) ENGINE=InnoDB DEFAULT CHARSET=ucs2
+ALTER TABLE `ｱｱｱ` DROP INDEX `ｶｶｶ`;
+ALTER TABLE `ｱｱｱ` DROP PRIMARY KEY;
+ALTER TABLE `ｱｱｱ` DROP INDEX `ｸｸｸ`;
+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=InnoDB DEFAULT CHARSET=ucs2
+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 `あああ` ADD UNIQUE (`くくく`);
+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 MUL 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 (`ききき`),
+ UNIQUE KEY `くくく` (`くくく`),
+ KEY `かかか` (`かか`)
+) ENGINE=InnoDB DEFAULT CHARSET=ucs2
+ALTER TABLE `あああ` DROP INDEX `かかか`;
+ALTER TABLE `あああ` DROP PRIMARY KEY;
+ALTER TABLE `あああ` DROP INDEX `くくく`;
+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=InnoDB DEFAULT CHARSET=ucs2
+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 `龖龖龖` ADD UNIQUE (`丅丅丅`);
+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 MUL 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 (`丂丂丂`),
+ UNIQUE KEY `丅丅丅` (`丅丅丅`),
+ KEY `丄丄丄` (`丄丄`)
+) ENGINE=InnoDB DEFAULT CHARSET=ucs2
+ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
+ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
+ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
+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=InnoDB DEFAULT CHARSET=ucs2
+DROP TABLE `ｱｱｱ`;
+DROP TABLE `ｲｲｲ`;
+DROP TABLE `あああ`;
+DROP TABLE `いいい`;
+DROP TABLE `龖龖龖`;
+DROP TABLE `龗龗龗`;
+CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = ucs2 engine=MYISAM;
+CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = ucs2 engine=MYISAM;
+CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = ucs2 engine=MYISAM;
+CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = ucs2 engine=MYISAM;
+CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = ucs2 engine=MYISAM;
+CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = ucs2 engine=MYISAM;
+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 `ｱｱｱ` ADD UNIQUE (`ｸｸｸ`);
+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 MUL 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 (`ｷｷｷ`),
+ UNIQUE KEY `ｸｸｸ` (`ｸｸｸ`),
+ KEY `ｶｶｶ` (`ｶｶ`)
+) ENGINE=MyISAM DEFAULT CHARSET=ucs2
+ALTER TABLE `ｱｱｱ` DROP INDEX `ｶｶｶ`;
+ALTER TABLE `ｱｱｱ` DROP PRIMARY KEY;
+ALTER TABLE `ｱｱｱ` DROP INDEX `ｸｸｸ`;
+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=MyISAM DEFAULT CHARSET=ucs2
+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 `あああ` ADD UNIQUE (`くくく`);
+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 MUL 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 (`ききき`),
+ UNIQUE KEY `くくく` (`くくく`),
+ KEY `かかか` (`かか`)
+) ENGINE=MyISAM DEFAULT CHARSET=ucs2
+ALTER TABLE `あああ` DROP INDEX `かかか`;
+ALTER TABLE `あああ` DROP PRIMARY KEY;
+ALTER TABLE `あああ` DROP INDEX `くくく`;
+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=MyISAM DEFAULT CHARSET=ucs2
+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 `龖龖龖` ADD UNIQUE (`丅丅丅`);
+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 MUL 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 (`丂丂丂`),
+ UNIQUE KEY `丅丅丅` (`丅丅丅`),
+ KEY `丄丄丄` (`丄丄`)
+) ENGINE=MyISAM DEFAULT CHARSET=ucs2
+ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
+ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
+ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
+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=MyISAM DEFAULT CHARSET=ucs2
+DROP TABLE `ｱｱｱ`;
+DROP TABLE `ｲｲｲ`;
+DROP TABLE `あああ`;
+DROP TABLE `いいい`;
+DROP TABLE `龖龖龖`;
+DROP TABLE `龗龗龗`;
+CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = ucs2 engine=HEAP;
+CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = ucs2 engine=HEAP;
+CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = ucs2 engine=HEAP;
+CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = ucs2 engine=HEAP;
+CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = ucs2 engine=HEAP;
+CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = ucs2 engine=HEAP;
+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 `ｱｱｱ` ADD UNIQUE (`ｸｸｸ`);
+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 MUL 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 (`ｷｷｷ`),
+ UNIQUE KEY `ｸｸｸ` (`ｸｸｸ`),
+ KEY `ｶｶｶ` (`ｶｶ`)
+) ENGINE=HEAP DEFAULT CHARSET=ucs2
+ALTER TABLE `ｱｱｱ` DROP INDEX `ｶｶｶ`;
+ALTER TABLE `ｱｱｱ` DROP PRIMARY KEY;
+ALTER TABLE `ｱｱｱ` DROP INDEX `ｸｸｸ`;
+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=HEAP DEFAULT CHARSET=ucs2
+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 `あああ` ADD UNIQUE (`くくく`);
+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 MUL 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 (`ききき`),
+ UNIQUE KEY `くくく` (`くくく`),
+ KEY `かかか` (`かか`)
+) ENGINE=HEAP DEFAULT CHARSET=ucs2
+ALTER TABLE `あああ` DROP INDEX `かかか`;
+ALTER TABLE `あああ` DROP PRIMARY KEY;
+ALTER TABLE `あああ` DROP INDEX `くくく`;
+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=HEAP DEFAULT CHARSET=ucs2
+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 `龖龖龖` ADD UNIQUE (`丅丅丅`);
+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 MUL 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 (`丂丂丂`),
+ UNIQUE KEY `丅丅丅` (`丅丅丅`),
+ KEY `丄丄丄` (`丄丄`)
+) ENGINE=HEAP DEFAULT CHARSET=ucs2
+ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
+ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
+ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
+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=HEAP DEFAULT CHARSET=ucs2
+DROP TABLE `ｱｱｱ`;
+DROP TABLE `ｲｲｲ`;
+DROP TABLE `あああ`;
+DROP TABLE `いいい`;
+DROP TABLE `龖龖龖`;
+DROP TABLE `龗龗龗`;
+CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = ucs2 engine=BDB;
+CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = ucs2 engine=BDB;
+CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = ucs2 engine=BDB;
+CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = ucs2 engine=BDB;
+CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = ucs2 engine=BDB;
+CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = ucs2 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=ucs2
+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=ucs2
+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=ucs2
+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=ucs2
+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=ucs2
+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=ucs2
+DROP TABLE `ｱｱｱ`;
+DROP TABLE `ｲｲｲ`;
+DROP TABLE `あああ`;
+DROP TABLE `いいい`;
+DROP TABLE `龖龖龖`;
+DROP TABLE `龗龗龗`;
View Lorry Controller Status