74 lines
2.2 KiB
Plaintext
74 lines
2.2 KiB
Plaintext
DROP TABLE IF EXISTS m2;
|
|
CREATE TABLE m2(c1 CHAR(1) NULL, c2 CHAR(5) NOT NULL, c3 CHAR(255) NULL, c4 CHAR(4) NOT NULL PRIMARY KEY, c5 CHAR(30) NOT NULL UNIQUE KEY);
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
m2
|
|
SHOW CREATE TABLE m2;
|
|
Table Create Table
|
|
m2 CREATE TABLE `m2` (
|
|
`c1` char(1) DEFAULT NULL,
|
|
`c2` char(5) NOT NULL,
|
|
`c3` char(255) DEFAULT NULL,
|
|
`c4` char(4) NOT NULL,
|
|
`c5` char(30) NOT NULL,
|
|
PRIMARY KEY (`c4`),
|
|
UNIQUE KEY `c5` (`c5`)
|
|
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
DROP TABLE m2;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE m2(c1 VARCHAR(1) NULL, c2 VARCHAR(5) NOT NULL, c3 VARCHAR(255) NULL, c4 VARCHAR(4) NOT NULL PRIMARY KEY, c5 VARCHAR(30) NOT NULL UNIQUE KEY);
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
m2
|
|
SHOW CREATE TABLE m2;
|
|
Table Create Table
|
|
m2 CREATE TABLE `m2` (
|
|
`c1` varchar(1) DEFAULT NULL,
|
|
`c2` varchar(5) NOT NULL,
|
|
`c3` varchar(255) DEFAULT NULL,
|
|
`c4` varchar(4) NOT NULL,
|
|
`c5` varchar(30) NOT NULL,
|
|
PRIMARY KEY (`c4`),
|
|
UNIQUE KEY `c5` (`c5`)
|
|
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
DROP TABLE m2;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE m2(c1 BINARY(1) NULL, c2 BINARY(5) NOT NULL, c3 BINARY(255) NULL, c4 BINARY(4) NOT NULL PRIMARY KEY, c5 BINARY(30) NOT NULL UNIQUE KEY);
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
m2
|
|
SHOW CREATE TABLE m2;
|
|
Table Create Table
|
|
m2 CREATE TABLE `m2` (
|
|
`c1` binary(1) DEFAULT NULL,
|
|
`c2` binary(5) NOT NULL,
|
|
`c3` binary(255) DEFAULT NULL,
|
|
`c4` binary(4) NOT NULL,
|
|
`c5` binary(30) NOT NULL,
|
|
PRIMARY KEY (`c4`),
|
|
UNIQUE KEY `c5` (`c5`)
|
|
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
DROP TABLE m2;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE m2(c1 VARBINARY(1) NULL, c2 VARBINARY(5) NOT NULL, c3 VARBINARY(255) NULL, c4 VARBINARY(4) NOT NULL PRIMARY KEY, c5 VARBINARY(30) NOT NULL UNIQUE KEY);
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
m2
|
|
SHOW CREATE TABLE m2;
|
|
Table Create Table
|
|
m2 CREATE TABLE `m2` (
|
|
`c1` varbinary(1) DEFAULT NULL,
|
|
`c2` varbinary(5) NOT NULL,
|
|
`c3` varbinary(255) DEFAULT NULL,
|
|
`c4` varbinary(4) NOT NULL,
|
|
`c5` varbinary(30) NOT NULL,
|
|
PRIMARY KEY (`c4`),
|
|
UNIQUE KEY `c5` (`c5`)
|
|
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
DROP TABLE m2;
|
|
SHOW TABLES;
|
|
Tables_in_test
|