jp_enum_utf8.result

来自「这个文件是windows mysql源码」· RESULT 代码 · 共 363 行

drop table if exists `Ｔ１`;
drop table if exists `Ｔ２`;
drop table if exists `Ｔ３`;
drop table if exists `Ｔ４`;
drop table if exists `Ｔ５`;
drop table if exists `Ｔ６`;
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 utf8;
SET character_set_database = utf8;
CREATE TABLE `Ｔ１` (`Ｃ１` ENUM('ｱ','ｲ','ｳ'), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ２` (`Ｃ１` ENUM('あ','い','う'), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ３` (`Ｃ１` ENUM('龔','龖','龗'), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ４` (`Ｃ１` ENUM('ｱ','ｲ','ｳ'), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam;
CREATE TABLE `Ｔ５` (`Ｃ１` ENUM('あ','い','う'), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam;
CREATE TABLE `Ｔ６` (`Ｃ１` ENUM('龔','龖','龗'), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam;
CREATE TABLE `Ｔ７` (`Ｃ１` ENUM('ｱ','ｲ','ｳ'), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = heap;
CREATE TABLE `Ｔ８` (`Ｃ１` ENUM('あ','い','う'), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = heap;
CREATE TABLE `Ｔ９` (`Ｃ１` ENUM('龔','龖','龗'), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = heap;
CREATE TABLE `Ｔ１０` (`Ｃ１` ENUM('ｱ','ｲ','ｳ'), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = bdb;
CREATE TABLE `Ｔ１１` (`Ｃ１` ENUM('あ','い','う'), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = bdb;
CREATE TABLE `Ｔ１２` (`Ｃ１` ENUM('龔','龖','龗'), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = bdb;
INSERT INTO `Ｔ１` VALUES ('ｱ'),('ｲ'),('ｳ');
INSERT INTO `Ｔ２` VALUES ('あ'),('い'),('う');
INSERT INTO `Ｔ３` VALUES ('龔'),('龖'),('龗');
INSERT INTO `Ｔ４` VALUES ('ｱ'),('ｲ'),('ｳ');
INSERT INTO `Ｔ５` VALUES ('あ'),('い'),('う');
INSERT INTO `Ｔ６` VALUES ('龔'),('龖'),('龗');
INSERT INTO `Ｔ７` VALUES ('ｱ'),('ｲ'),('ｳ');
INSERT INTO `Ｔ８` VALUES ('あ'),('い'),('う');
INSERT INTO `Ｔ９` VALUES ('龔'),('龖'),('龗');
INSERT INTO `Ｔ１０` VALUES ('ｱ'),('ｲ'),('ｳ');
INSERT INTO `Ｔ１１` VALUES ('あ'),('い'),('う');
INSERT INTO `Ｔ１２` VALUES ('龔'),('龖'),('龗');
SELECT * FROM `Ｔ１`;
Ｃ１
ｱ
ｲ
ｳ
SELECT * FROM `Ｔ２`;
Ｃ１
あ
い
う
SELECT * FROM `Ｔ３`;
Ｃ１
龔
龖
龗
SELECT * FROM `Ｔ４`;
Ｃ１
ｱ
ｲ
ｳ
SELECT * FROM `Ｔ５`;
Ｃ１
あ
い
う
SELECT * FROM `Ｔ６`;
Ｃ１
龔
龖
龗
SELECT * FROM `Ｔ７`;
Ｃ１
ｱ
ｲ
ｳ
SELECT * FROM `Ｔ８`;
Ｃ１
あ
い
う
SELECT * FROM `Ｔ９`;
Ｃ１
龔
龖
龗
SELECT * FROM `Ｔ１０`;
Ｃ１
ｱ
ｲ
ｳ
SELECT * FROM `Ｔ１１`;
Ｃ１
あ
い
う
SELECT * FROM `Ｔ１２`;
Ｃ１
龔
龖
龗
SHOW CREATE TABLE `Ｔ１`;
Table	Create Table
Ｔ１	CREATE TABLE `Ｔ１` (
  `Ｃ１` enum('ｱ','ｲ','ｳ') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ２`;
Table	Create Table
Ｔ２	CREATE TABLE `Ｔ２` (
  `Ｃ１` enum('あ','い','う') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ３`;
Table	Create Table
Ｔ３	CREATE TABLE `Ｔ３` (
  `Ｃ１` enum('龔','龖','龗') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ４`;
Table	Create Table
Ｔ４	CREATE TABLE `Ｔ４` (
  `Ｃ１` enum('ｱ','ｲ','ｳ') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ５`;
Table	Create Table
Ｔ５	CREATE TABLE `Ｔ５` (
  `Ｃ１` enum('あ','い','う') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ６`;
Table	Create Table
Ｔ６	CREATE TABLE `Ｔ６` (
  `Ｃ１` enum('龔','龖','龗') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ７`;
Table	Create Table
Ｔ７	CREATE TABLE `Ｔ７` (
  `Ｃ１` enum('ｱ','ｲ','ｳ') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=HEAP DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ８`;
Table	Create Table
Ｔ８	CREATE TABLE `Ｔ８` (
  `Ｃ１` enum('あ','い','う') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=HEAP DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ９`;
Table	Create Table
Ｔ９	CREATE TABLE `Ｔ９` (
  `Ｃ１` enum('龔','龖','龗') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=HEAP DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ１０`;
Table	Create Table
Ｔ１０	CREATE TABLE `Ｔ１０` (
  `Ｃ１` enum('ｱ','ｲ','ｳ') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ１１`;
Table	Create Table
Ｔ１１	CREATE TABLE `Ｔ１１` (
  `Ｃ１` enum('あ','い','う') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ１２`;
Table	Create Table
Ｔ１２	CREATE TABLE `Ｔ１２` (
  `Ｃ１` enum('龔','龖','龗') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
DESC `Ｔ１`;
Field	Type	Null	Key	Default	Extra
Ｃ１	enum('ｱ','ｲ','ｳ')	YES	MUL	NULL	
DESC `Ｔ２`;
Field	Type	Null	Key	Default	Extra
Ｃ１	enum('あ','い','う')	YES	MUL	NULL	
DESC `Ｔ３`;
Field	Type	Null	Key	Default	Extra
Ｃ１	enum('龔','龖','龗')	YES	MUL	NULL	
DESC `Ｔ４`;
Field	Type	Null	Key	Default	Extra
Ｃ１	enum('ｱ','ｲ','ｳ')	YES	MUL	NULL	
DESC `Ｔ５`;
Field	Type	Null	Key	Default	Extra
Ｃ１	enum('あ','い','う')	YES	MUL	NULL	
DESC `Ｔ６`;
Field	Type	Null	Key	Default	Extra
Ｃ１	enum('龔','龖','龗')	YES	MUL	NULL	
DESC `Ｔ７`;
Field	Type	Null	Key	Default	Extra
Ｃ１	enum('ｱ','ｲ','ｳ')	YES	MUL	NULL	
DESC `Ｔ８`;
Field	Type	Null	Key	Default	Extra
Ｃ１	enum('あ','い','う')	YES	MUL	NULL	
DESC `Ｔ９`;
Field	Type	Null	Key	Default	Extra
Ｃ１	enum('龔','龖','龗')	YES	MUL	NULL	
DESC `Ｔ１０`;
Field	Type	Null	Key	Default	Extra
Ｃ１	enum('ｱ','ｲ','ｳ')	YES	MUL	NULL	
DESC `Ｔ１１`;
Field	Type	Null	Key	Default	Extra
Ｃ１	enum('あ','い','う')	YES	MUL	NULL	
DESC `Ｔ１２`;
Field	Type	Null	Key	Default	Extra
Ｃ１	enum('龔','龖','龗')	YES	MUL	NULL	
ALTER TABLE `Ｔ１` ADD `Ｃ２` CHAR(1) NOT NULL FIRST;
ALTER TABLE `Ｔ２` ADD `Ｃ２` CHAR(1) NOT NULL FIRST;
ALTER TABLE `Ｔ３` ADD `Ｃ２` CHAR(1) NOT NULL FIRST;
ALTER TABLE `Ｔ４` ADD `Ｃ２` CHAR(1) NOT NULL FIRST;
ALTER TABLE `Ｔ５` ADD `Ｃ２` CHAR(1) NOT NULL FIRST;
ALTER TABLE `Ｔ６` ADD `Ｃ２` CHAR(1) NOT NULL FIRST;
ALTER TABLE `Ｔ７` ADD `Ｃ２` CHAR(1) NOT NULL FIRST;
ALTER TABLE `Ｔ８` ADD `Ｃ２` CHAR(1) NOT NULL FIRST;
ALTER TABLE `Ｔ９` ADD `Ｃ２` CHAR(1) NOT NULL FIRST;
ALTER TABLE `Ｔ１０` ADD `Ｃ２` CHAR(1) NOT NULL FIRST;
ALTER TABLE `Ｔ１１` ADD `Ｃ２` CHAR(1) NOT NULL FIRST;
ALTER TABLE `Ｔ１２` ADD `Ｃ２` CHAR(1) NOT NULL FIRST;
SHOW CREATE TABLE `Ｔ１`;
Table	Create Table
Ｔ１	CREATE TABLE `Ｔ１` (
  `Ｃ２` char(1) NOT NULL default '',
  `Ｃ１` enum('ｱ','ｲ','ｳ') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ２`;
Table	Create Table
Ｔ２	CREATE TABLE `Ｔ２` (
  `Ｃ２` char(1) NOT NULL default '',
  `Ｃ１` enum('あ','い','う') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ３`;
Table	Create Table
Ｔ３	CREATE TABLE `Ｔ３` (
  `Ｃ２` char(1) NOT NULL default '',
  `Ｃ１` enum('龔','龖','龗') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ４`;
Table	Create Table
Ｔ４	CREATE TABLE `Ｔ４` (
  `Ｃ２` char(1) NOT NULL default '',
  `Ｃ１` enum('ｱ','ｲ','ｳ') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ５`;
Table	Create Table
Ｔ５	CREATE TABLE `Ｔ５` (
  `Ｃ２` char(1) NOT NULL default '',
  `Ｃ１` enum('あ','い','う') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ６`;
Table	Create Table
Ｔ６	CREATE TABLE `Ｔ６` (
  `Ｃ２` char(1) NOT NULL default '',
  `Ｃ１` enum('龔','龖','龗') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ７`;
Table	Create Table
Ｔ７	CREATE TABLE `Ｔ７` (
  `Ｃ２` char(1) NOT NULL default '',
  `Ｃ１` enum('ｱ','ｲ','ｳ') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=HEAP DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ８`;
Table	Create Table
Ｔ８	CREATE TABLE `Ｔ８` (
  `Ｃ２` char(1) NOT NULL default '',
  `Ｃ１` enum('あ','い','う') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=HEAP DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ９`;
Table	Create Table
Ｔ９	CREATE TABLE `Ｔ９` (
  `Ｃ２` char(1) NOT NULL default '',
  `Ｃ１` enum('龔','龖','龗') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=HEAP DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ１０`;
Table	Create Table
Ｔ１０	CREATE TABLE `Ｔ１０` (
  `Ｃ２` char(1) NOT NULL default '',
  `Ｃ１` enum('ｱ','ｲ','ｳ') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ１１`;
Table	Create Table
Ｔ１１	CREATE TABLE `Ｔ１１` (
  `Ｃ２` char(1) NOT NULL default '',
  `Ｃ１` enum('あ','い','う') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ１２`;
Table	Create Table
Ｔ１２	CREATE TABLE `Ｔ１２` (
  `Ｃ２` char(1) NOT NULL default '',
  `Ｃ１` enum('龔','龖','龗') default NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
DESC `Ｔ１`;
Field	Type	Null	Key	Default	Extra
Ｃ２	char(1)				
Ｃ１	enum('ｱ','ｲ','ｳ')	YES	MUL	NULL	
DESC `Ｔ２`;
Field	Type	Null	Key	Default	Extra
Ｃ２	char(1)				
Ｃ１	enum('あ','い','う')	YES	MUL	NULL	
DESC `Ｔ３`;
Field	Type	Null	Key	Default	Extra
Ｃ２	char(1)				
Ｃ１	enum('龔','龖','龗')	YES	MUL	NULL	
DESC `Ｔ４`;
Field	Type	Null	Key	Default	Extra
Ｃ２	char(1)				
Ｃ１	enum('ｱ','ｲ','ｳ')	YES	MUL	NULL	
DESC `Ｔ５`;
Field	Type	Null	Key	Default	Extra
Ｃ２	char(1)				
Ｃ１	enum('あ','い','う')	YES	MUL	NULL	
DESC `Ｔ６`;
Field	Type	Null	Key	Default	Extra
Ｃ２	char(1)				
Ｃ１	enum('龔','龖','龗')	YES	MUL	NULL	
DESC `Ｔ７`;
Field	Type	Null	Key	Default	Extra
Ｃ２	char(1)				
Ｃ１	enum('ｱ','ｲ','ｳ')	YES	MUL	NULL	
DESC `Ｔ８`;
Field	Type	Null	Key	Default	Extra
Ｃ２	char(1)				
Ｃ１	enum('あ','い','う')	YES	MUL	NULL	
DESC `Ｔ９`;
Field	Type	Null	Key	Default	Extra
Ｃ２	char(1)				
Ｃ１	enum('龔','龖','龗')	YES	MUL	NULL	
DESC `Ｔ１０`;
Field	Type	Null	Key	Default	Extra
Ｃ２	char(1)				
Ｃ１	enum('ｱ','ｲ','ｳ')	YES	MUL	NULL	
DESC `Ｔ１１`;
Field	Type	Null	Key	Default	Extra
Ｃ２	char(1)				
Ｃ１	enum('あ','い','う')	YES	MUL	NULL	
DESC `Ｔ１２`;
Field	Type	Null	Key	Default	Extra
Ｃ２	char(1)				
Ｃ１	enum('龔','龖','龗')	YES	MUL	NULL	
DROP TABLE `Ｔ１`;
DROP TABLE `Ｔ２`;
DROP TABLE `Ｔ３`;
DROP TABLE `Ｔ４`;
DROP TABLE `Ｔ５`;
DROP TABLE `Ｔ６`;
DROP TABLE `Ｔ７`;
DROP TABLE `Ｔ８`;
DROP TABLE `Ｔ９`;
DROP TABLE `Ｔ１０`;
DROP TABLE `Ｔ１１`;
DROP TABLE `Ｔ１２`;