1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
|
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=latin1
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=latin1
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=latin1
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=latin1
DROP TABLE m2;
SHOW TABLES;
Tables_in_test
|