1 DROP TABLE IF EXISTS src,dest;
2 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 CHAR(10) NULL, PRIMARY KEY(c1));
3 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
10 dst CREATE TABLE `dst` (
11 `c1` int(11) NOT NULL AUTO_INCREMENT,
12 `c2` char(10) DEFAULT NULL,
14 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
19 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
24 SHOW CREATE TABLE dst;
26 dst CREATE TABLE `dst` (
27 `c1` int(11) NOT NULL AUTO_INCREMENT,
28 `c2` char(10) DEFAULT NULL,
30 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
36 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 VARCHAR(10) NULL, PRIMARY KEY(c1));
37 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
42 SHOW CREATE TABLE dst;
44 dst CREATE TABLE `dst` (
45 `c1` int(11) NOT NULL AUTO_INCREMENT,
46 `c2` varchar(10) DEFAULT NULL,
48 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
53 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
58 SHOW CREATE TABLE dst;
60 dst CREATE TABLE `dst` (
61 `c1` int(11) NOT NULL AUTO_INCREMENT,
62 `c2` varchar(10) DEFAULT NULL,
64 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
70 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BINARY(10) NULL, PRIMARY KEY(c1));
71 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
76 SHOW CREATE TABLE dst;
78 dst CREATE TABLE `dst` (
79 `c1` int(11) NOT NULL AUTO_INCREMENT,
80 `c2` binary(10) DEFAULT NULL,
82 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
87 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
92 SHOW CREATE TABLE dst;
94 dst CREATE TABLE `dst` (
95 `c1` int(11) NOT NULL AUTO_INCREMENT,
96 `c2` binary(10) DEFAULT NULL,
98 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
104 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 VARBINARY(10) NULL, PRIMARY KEY(c1));
105 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
110 SHOW CREATE TABLE dst;
112 dst CREATE TABLE `dst` (
113 `c1` int(11) NOT NULL AUTO_INCREMENT,
114 `c2` varbinary(10) DEFAULT NULL,
116 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
121 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
126 SHOW CREATE TABLE dst;
128 dst CREATE TABLE `dst` (
129 `c1` int(11) NOT NULL AUTO_INCREMENT,
130 `c2` varbinary(10) DEFAULT NULL,
132 ) ENGINE=MyISAM DEFAULT CHARSET=latin1