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