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