drop table if exists `T1`;
drop table if exists `T2`;
drop table if exists `T3`;
drop table if exists `T4`;
drop table if exists `T5`;
drop table if exists `T6`;
drop table if exists `T7`;
drop table if exists `T8`;
drop table if exists `T9`;
SET NAMES utf8;
SET character_set_database = utf8;
CREATE TABLE `T1` (`C1` ENUM('ア' ,'イ' ,'ウ' ), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `T2` (`C1` ENUM('あ' ,'い' ,'う' ), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `T3` (`C1` ENUM('龔' ,'龖' ,'龗' ), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `T4` (`C1` ENUM('ア' ,'イ' ,'ウ' ), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
CREATE TABLE `T5` (`C1` ENUM('あ' ,'い' ,'う' ), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
CREATE TABLE `T6` (`C1` ENUM('龔' ,'龖' ,'龗' ), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
CREATE TABLE `T7` (`C1` ENUM('ア' ,'イ' ,'ウ' ), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
CREATE TABLE `T8` (`C1` ENUM('あ' ,'い' ,'う' ), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
CREATE TABLE `T9` (`C1` ENUM('龔' ,'龖' ,'龗' ), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
INSERT INTO `T1` VALUES ('ア' ),('イ' ),('ウ' );
INSERT INTO `T2` VALUES ('あ' ),('い' ),('う' );
INSERT INTO `T3` VALUES ('龔' ),('龖' ),('龗' );
INSERT INTO `T4` VALUES ('ア' ),('イ' ),('ウ' );
INSERT INTO `T5` VALUES ('あ' ),('い' ),('う' );
INSERT INTO `T6` VALUES ('龔' ),('龖' ),('龗' );
INSERT INTO `T7` VALUES ('ア' ),('イ' ),('ウ' );
INSERT INTO `T8` VALUES ('あ' ),('い' ),('う' );
INSERT INTO `T9` VALUES ('龔' ),('龖' ),('龗' );
SELECT * FROM `T1`;
C1
ア
イ
ウ
SELECT * FROM `T2`;
C1
あ
い
う
SELECT * FROM `T3`;
C1
龔
龖
龗
SELECT * FROM `T4`;
C1
ア
イ
ウ
SELECT * FROM `T5`;
C1
あ
い
う
SELECT * FROM `T6`;
C1
龔
龖
龗
SELECT * FROM `T7`;
C1
ア
イ
ウ
SELECT * FROM `T8`;
C1
あ
い
う
SELECT * FROM `T9`;
C1
龔
龖
龗
SHOW CREATE TABLE `T1`;
Table Create Table
T1 CREATE TABLE `T1` (
`C1` enum('ア' ,'イ' ,'ウ' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
SHOW CREATE TABLE `T2`;
Table Create Table
T2 CREATE TABLE `T2` (
`C1` enum('あ' ,'い' ,'う' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
SHOW CREATE TABLE `T3`;
Table Create Table
T3 CREATE TABLE `T3` (
`C1` enum('龔' ,'龖' ,'龗' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
SHOW CREATE TABLE `T4`;
Table Create Table
T4 CREATE TABLE `T4` (
`C1` enum('ア' ,'イ' ,'ウ' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
SHOW CREATE TABLE `T5`;
Table Create Table
T5 CREATE TABLE `T5` (
`C1` enum('あ' ,'い' ,'う' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
SHOW CREATE TABLE `T6`;
Table Create Table
T6 CREATE TABLE `T6` (
`C1` enum('龔' ,'龖' ,'龗' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
SHOW CREATE TABLE `T7`;
Table Create Table
T7 CREATE TABLE `T7` (
`C1` enum('ア' ,'イ' ,'ウ' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
SHOW CREATE TABLE `T8`;
Table Create Table
T8 CREATE TABLE `T8` (
`C1` enum('あ' ,'い' ,'う' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
SHOW CREATE TABLE `T9`;
Table Create Table
T9 CREATE TABLE `T9` (
`C1` enum('龔' ,'龖' ,'龗' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DESC `T1`;
Field Type Null Key Default Extra
C1 enum('ア' ,'イ' ,'ウ' ) YES MUL NULL
DESC `T2`;
Field Type Null Key Default Extra
C1 enum('あ' ,'い' ,'う' ) YES MUL NULL
DESC `T3`;
Field Type Null Key Default Extra
C1 enum('龔' ,'龖' ,'龗' ) YES MUL NULL
DESC `T4`;
Field Type Null Key Default Extra
C1 enum('ア' ,'イ' ,'ウ' ) YES MUL NULL
DESC `T5`;
Field Type Null Key Default Extra
C1 enum('あ' ,'い' ,'う' ) YES MUL NULL
DESC `T6`;
Field Type Null Key Default Extra
C1 enum('龔' ,'龖' ,'龗' ) YES MUL NULL
DESC `T7`;
Field Type Null Key Default Extra
C1 enum('ア' ,'イ' ,'ウ' ) YES MUL NULL
DESC `T8`;
Field Type Null Key Default Extra
C1 enum('あ' ,'い' ,'う' ) YES MUL NULL
DESC `T9`;
Field Type Null Key Default Extra
C1 enum('龔' ,'龖' ,'龗' ) YES MUL NULL
ALTER TABLE `T1` ADD `C2` CHAR(1 ) NOT NULL FIRST;
ALTER TABLE `T2` ADD `C2` CHAR(1 ) NOT NULL FIRST;
ALTER TABLE `T3` ADD `C2` CHAR(1 ) NOT NULL FIRST;
ALTER TABLE `T4` ADD `C2` CHAR(1 ) NOT NULL FIRST;
ALTER TABLE `T5` ADD `C2` CHAR(1 ) NOT NULL FIRST;
ALTER TABLE `T6` ADD `C2` CHAR(1 ) NOT NULL FIRST;
ALTER TABLE `T7` ADD `C2` CHAR(1 ) NOT NULL FIRST;
ALTER TABLE `T8` ADD `C2` CHAR(1 ) NOT NULL FIRST;
ALTER TABLE `T9` ADD `C2` CHAR(1 ) NOT NULL FIRST;
SHOW CREATE TABLE `T1`;
Table Create Table
T1 CREATE TABLE `T1` (
`C2` char(1 ) NOT NULL,
`C1` enum('ア' ,'イ' ,'ウ' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
SHOW CREATE TABLE `T2`;
Table Create Table
T2 CREATE TABLE `T2` (
`C2` char(1 ) NOT NULL,
`C1` enum('あ' ,'い' ,'う' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
SHOW CREATE TABLE `T3`;
Table Create Table
T3 CREATE TABLE `T3` (
`C2` char(1 ) NOT NULL,
`C1` enum('龔' ,'龖' ,'龗' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
SHOW CREATE TABLE `T4`;
Table Create Table
T4 CREATE TABLE `T4` (
`C2` char(1 ) NOT NULL,
`C1` enum('ア' ,'イ' ,'ウ' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
SHOW CREATE TABLE `T5`;
Table Create Table
T5 CREATE TABLE `T5` (
`C2` char(1 ) NOT NULL,
`C1` enum('あ' ,'い' ,'う' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
SHOW CREATE TABLE `T6`;
Table Create Table
T6 CREATE TABLE `T6` (
`C2` char(1 ) NOT NULL,
`C1` enum('龔' ,'龖' ,'龗' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
SHOW CREATE TABLE `T7`;
Table Create Table
T7 CREATE TABLE `T7` (
`C2` char(1 ) NOT NULL,
`C1` enum('ア' ,'イ' ,'ウ' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
SHOW CREATE TABLE `T8`;
Table Create Table
T8 CREATE TABLE `T8` (
`C2` char(1 ) NOT NULL,
`C1` enum('あ' ,'い' ,'う' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
SHOW CREATE TABLE `T9`;
Table Create Table
T9 CREATE TABLE `T9` (
`C2` char(1 ) NOT NULL,
`C1` enum('龔' ,'龖' ,'龗' ) DEFAULT NULL,
KEY `C1` (`C1`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DESC `T1`;
Field Type Null Key Default Extra
C2 char(1 ) NO NULL
C1 enum('ア' ,'イ' ,'ウ' ) YES MUL NULL
DESC `T2`;
Field Type Null Key Default Extra
C2 char(1 ) NO NULL
C1 enum('あ' ,'い' ,'う' ) YES MUL NULL
DESC `T3`;
Field Type Null Key Default Extra
C2 char(1 ) NO NULL
C1 enum('龔' ,'龖' ,'龗' ) YES MUL NULL
DESC `T4`;
Field Type Null Key Default Extra
C2 char(1 ) NO NULL
C1 enum('ア' ,'イ' ,'ウ' ) YES MUL NULL
DESC `T5`;
Field Type Null Key Default Extra
C2 char(1 ) NO NULL
C1 enum('あ' ,'い' ,'う' ) YES MUL NULL
DESC `T6`;
Field Type Null Key Default Extra
C2 char(1 ) NO NULL
C1 enum('龔' ,'龖' ,'龗' ) YES MUL NULL
DESC `T7`;
Field Type Null Key Default Extra
C2 char(1 ) NO NULL
C1 enum('ア' ,'イ' ,'ウ' ) YES MUL NULL
DESC `T8`;
Field Type Null Key Default Extra
C2 char(1 ) NO NULL
C1 enum('あ' ,'い' ,'う' ) YES MUL NULL
DESC `T9`;
Field Type Null Key Default Extra
C2 char(1 ) NO NULL
C1 enum('龔' ,'龖' ,'龗' ) YES MUL NULL
DROP TABLE `T1`;
DROP TABLE `T2`;
DROP TABLE `T3`;
DROP TABLE `T4`;
DROP TABLE `T5`;
DROP TABLE `T6`;
DROP TABLE `T7`;
DROP TABLE `T8`;
DROP TABLE `T9`;
Messung V0.5 in Prozent C=60 H=100 G=82
¤ Dauer der Verarbeitung: 0.7 Sekunden
(vorverarbeitet am 2026-10-10)
¤
*© Formatika GbR, Deutschland