1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 CHAR(30) NOT NULL, c2 CHAR(20) NOT NULL, c3 CHAR(10) NOT NULL);
9
`c1` char(30) NOT NULL,
10
`c2` char(20) NOT NULL,
11
`c3` char(10) NOT NULL
12
) ENGINE=ENGINE DEFAULT CHARSET=latin1
13
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
19
t1 CREATE TABLE `t1` (
20
`c1` char(30) NOT NULL,
21
`c2` char(20) NOT NULL,
22
`c3` char(10) NOT NULL,
23
PRIMARY KEY (`c1`,`c2`)
24
) ENGINE=ENGINE DEFAULT CHARSET=latin1
28
CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 VARCHAR(20) NOT NULL, c3 VARCHAR(10) NOT NULL);
34
t1 CREATE TABLE `t1` (
35
`c1` varchar(30) NOT NULL,
36
`c2` varchar(20) NOT NULL,
37
`c3` varchar(10) NOT NULL
38
) ENGINE=ENGINE DEFAULT CHARSET=latin1
39
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
45
t1 CREATE TABLE `t1` (
46
`c1` varchar(30) NOT NULL,
47
`c2` varchar(20) NOT NULL,
48
`c3` varchar(10) NOT NULL,
49
PRIMARY KEY (`c1`,`c2`)
50
) ENGINE=ENGINE DEFAULT CHARSET=latin1
54
CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 BINARY(20) NOT NULL, c3 BINARY(10) NOT NULL);
60
t1 CREATE TABLE `t1` (
61
`c1` binary(30) NOT NULL,
62
`c2` binary(20) NOT NULL,
63
`c3` binary(10) NOT NULL
64
) ENGINE=ENGINE DEFAULT CHARSET=latin1
65
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
71
t1 CREATE TABLE `t1` (
72
`c1` binary(30) NOT NULL,
73
`c2` binary(20) NOT NULL,
74
`c3` binary(10) NOT NULL,
75
PRIMARY KEY (`c1`,`c2`)
76
) ENGINE=ENGINE DEFAULT CHARSET=latin1
80
CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 VARBINARY(20) NOT NULL, c3 VARBINARY(10) NOT NULL);
86
t1 CREATE TABLE `t1` (
87
`c1` varbinary(30) NOT NULL,
88
`c2` varbinary(20) NOT NULL,
89
`c3` varbinary(10) NOT NULL
90
) ENGINE=ENGINE DEFAULT CHARSET=latin1
91
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
97
t1 CREATE TABLE `t1` (
98
`c1` varbinary(30) NOT NULL,
99
`c2` varbinary(20) NOT NULL,
100
`c3` varbinary(10) NOT NULL,
101
PRIMARY KEY (`c1`,`c2`)
102
) ENGINE=ENGINE DEFAULT CHARSET=latin1