| Server IP : 104.21.38.3 / Your IP : 162.158.108.159 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/jp/r/ |
Upload File : |
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;
Warnings:
Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
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 = MEMORY;
CREATE TABLE `Ｔ８` (`Ｃ１` ENUM('あ','い','う'), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = MEMORY;
CREATE TABLE `Ｔ９` (`Ｃ１` ENUM('龔','龖','龗'), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = MEMORY;
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 `Ｔ９`;
Ｃ１
龔
龖
龗
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=MEMORY DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ８`;
Table Create Table
Ｔ８ CREATE TABLE `Ｔ８` (
`Ｃ１` enum('あ','い','う') DEFAULT NULL,
KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ９`;
Table Create Table
Ｔ９ CREATE TABLE `Ｔ９` (
`Ｃ１` enum('龔','龖','龗') DEFAULT NULL,
KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MEMORY 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
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,
`Ｃ１` enum('ｱ','ｲ','ｳ') DEFAULT NULL,
KEY `Ｃ１` (`Ｃ１`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ２`;
Table Create Table
Ｔ２ CREATE TABLE `Ｔ２` (
`Ｃ２` char(1) NOT NULL,
`Ｃ１` enum('あ','い','う') DEFAULT NULL,
KEY `Ｃ１` (`Ｃ１`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ３`;
Table Create Table
Ｔ３ CREATE TABLE `Ｔ３` (
`Ｃ２` char(1) NOT NULL,
`Ｃ１` enum('龔','龖','龗') DEFAULT NULL,
KEY `Ｃ１` (`Ｃ１`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ４`;
Table Create Table
Ｔ４ CREATE TABLE `Ｔ４` (
`Ｃ２` char(1) NOT NULL,
`Ｃ１` enum('ｱ','ｲ','ｳ') DEFAULT NULL,
KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ５`;
Table Create Table
Ｔ５ CREATE TABLE `Ｔ５` (
`Ｃ２` char(1) NOT NULL,
`Ｃ１` enum('あ','い','う') DEFAULT NULL,
KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ６`;
Table Create Table
Ｔ６ CREATE TABLE `Ｔ６` (
`Ｃ２` char(1) NOT NULL,
`Ｃ１` enum('龔','龖','龗') DEFAULT NULL,
KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ７`;
Table Create Table
Ｔ７ CREATE TABLE `Ｔ７` (
`Ｃ２` char(1) NOT NULL,
`Ｃ１` enum('ｱ','ｲ','ｳ') DEFAULT NULL,
KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ８`;
Table Create Table
Ｔ８ CREATE TABLE `Ｔ８` (
`Ｃ２` char(1) NOT NULL,
`Ｃ１` enum('あ','い','う') DEFAULT NULL,
KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8
SHOW CREATE TABLE `Ｔ９`;
Table Create Table
Ｔ９ CREATE TABLE `Ｔ９` (
`Ｃ２` char(1) NOT NULL,
`Ｃ１` enum('龔','龖','龗') DEFAULT NULL,
KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8
DESC `Ｔ１`;
Field Type Null Key Default Extra
Ｃ２ char(1) NO NULL
Ｃ１ enum('ｱ','ｲ','ｳ') YES MUL NULL
DESC `Ｔ２`;
Field Type Null Key Default Extra
Ｃ２ char(1) NO NULL
Ｃ１ enum('あ','い','う') YES MUL NULL
DESC `Ｔ３`;
Field Type Null Key Default Extra
Ｃ２ char(1) NO NULL
Ｃ１ enum('龔','龖','龗') YES MUL NULL
DESC `Ｔ４`;
Field Type Null Key Default Extra
Ｃ２ char(1) NO NULL
Ｃ１ enum('ｱ','ｲ','ｳ') YES MUL NULL
DESC `Ｔ５`;
Field Type Null Key Default Extra
Ｃ２ char(1) NO NULL
Ｃ１ enum('あ','い','う') YES MUL NULL
DESC `Ｔ６`;
Field Type Null Key Default Extra
Ｃ２ char(1) NO NULL
Ｃ１ enum('龔','龖','龗') YES MUL NULL
DESC `Ｔ７`;
Field Type Null Key Default Extra
Ｃ２ char(1) NO NULL
Ｃ１ enum('ｱ','ｲ','ｳ') YES MUL NULL
DESC `Ｔ８`;
Field Type Null Key Default Extra
Ｃ２ char(1) NO NULL
Ｃ１ enum('あ','い','う') YES MUL NULL
DESC `Ｔ９`;
Field Type Null Key Default Extra
Ｃ２ char(1) NO NULL
Ｃ１ enum('龔','龖','龗') YES MUL NULL
DROP TABLE `Ｔ１`;
DROP TABLE `Ｔ２`;
DROP TABLE `Ｔ３`;
DROP TABLE `Ｔ４`;
DROP TABLE `Ｔ５`;
DROP TABLE `Ｔ６`;
DROP TABLE `Ｔ７`;
DROP TABLE `Ｔ８`;
DROP TABLE `Ｔ９`;