1 DROP TABLE IF EXISTS t1,t2;
2 CREATE TABLE t1 (x1 INT);
3 ALTER TABLE t1 CHANGE x1 x2 INT;
4 CREATE TABLE t2 LIKE t1;
8 `xx` int(11) DEFAULT NULL
9 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
11 ALTER TABLE t1 CHANGE x2 x1 INT;
12 CREATE TABLE t2 LIKE t1;
15 t2 CREATE TABLE `t2` (
16 `xx` int(11) DEFAULT NULL
17 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
19 ALTER TABLE t1 CHANGE x1 x2 INT;
20 CREATE TABLE t2 LIKE t1;
23 t2 CREATE TABLE `t2` (
24 `xx` int(11) DEFAULT NULL
25 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
27 ALTER TABLE t1 CHANGE x2 x1 INT;
28 CREATE TABLE t2 LIKE t1;
31 t2 CREATE TABLE `t2` (
32 `xx` int(11) DEFAULT NULL
33 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
35 ALTER TABLE t1 CHANGE x1 x2 INT;
36 CREATE TABLE t2 LIKE t1;
39 t2 CREATE TABLE `t2` (
40 `xx` int(11) DEFAULT NULL
41 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
43 ALTER TABLE t1 CHANGE x2 x1 INT;
44 CREATE TABLE t2 LIKE t1;
47 t2 CREATE TABLE `t2` (
48 `xx` int(11) DEFAULT NULL
49 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
51 ALTER TABLE t1 CHANGE x1 x2 INT;
52 CREATE TABLE t2 LIKE t1;
55 t2 CREATE TABLE `t2` (
56 `xx` int(11) DEFAULT NULL
57 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
59 ALTER TABLE t1 CHANGE x2 x1 INT;
60 CREATE TABLE t2 LIKE t1;
63 t2 CREATE TABLE `t2` (
64 `xx` int(11) DEFAULT NULL
65 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
67 ALTER TABLE t1 CHANGE x1 x2 INT;
68 CREATE TABLE t2 LIKE t1;
71 t2 CREATE TABLE `t2` (
72 `xx` int(11) DEFAULT NULL
73 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
75 ALTER TABLE t1 CHANGE x2 x1 INT;
76 CREATE TABLE t2 LIKE t1;
79 t2 CREATE TABLE `t2` (
80 `xx` int(11) DEFAULT NULL
81 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
83 ALTER TABLE t1 CHANGE x1 x2 INT;
84 CREATE TABLE t2 LIKE t1;
87 t2 CREATE TABLE `t2` (
88 `xx` int(11) DEFAULT NULL
89 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
91 ALTER TABLE t1 CHANGE x2 x1 INT;
92 CREATE TABLE t2 LIKE t1;
95 t2 CREATE TABLE `t2` (
96 `xx` int(11) DEFAULT NULL
97 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
99 ALTER TABLE t1 CHANGE x1 x2 INT;
100 CREATE TABLE t2 LIKE t1;
101 SHOW CREATE TABLE t2;
103 t2 CREATE TABLE `t2` (
104 `xx` int(11) DEFAULT NULL
105 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
107 ALTER TABLE t1 CHANGE x2 x1 INT;
108 CREATE TABLE t2 LIKE t1;
109 SHOW CREATE TABLE t2;
111 t2 CREATE TABLE `t2` (
112 `xx` int(11) DEFAULT NULL
113 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
115 ALTER TABLE t1 CHANGE x1 x2 INT;
116 CREATE TABLE t2 LIKE t1;
117 SHOW CREATE TABLE t2;
119 t2 CREATE TABLE `t2` (
120 `xx` int(11) DEFAULT NULL
121 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
123 ALTER TABLE t1 CHANGE x2 x1 INT;
124 CREATE TABLE t2 LIKE t1;
125 SHOW CREATE TABLE t2;
127 t2 CREATE TABLE `t2` (
128 `xx` int(11) DEFAULT NULL
129 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
131 ALTER TABLE t1 CHANGE x1 x2 INT;
132 CREATE TABLE t2 LIKE t1;
133 SHOW CREATE TABLE t2;
135 t2 CREATE TABLE `t2` (
136 `xx` int(11) DEFAULT NULL
137 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
139 ALTER TABLE t1 CHANGE x2 x1 INT;
140 CREATE TABLE t2 LIKE t1;
141 SHOW CREATE TABLE t2;
143 t2 CREATE TABLE `t2` (
144 `xx` int(11) DEFAULT NULL
145 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
147 ALTER TABLE t1 CHANGE x1 x2 INT;
148 CREATE TABLE t2 LIKE t1;
149 SHOW CREATE TABLE t2;
151 t2 CREATE TABLE `t2` (
152 `xx` int(11) DEFAULT NULL
153 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
155 ALTER TABLE t1 CHANGE x2 x1 INT;
156 CREATE TABLE t2 LIKE t1;
157 SHOW CREATE TABLE t2;
159 t2 CREATE TABLE `t2` (
160 `xx` int(11) DEFAULT NULL
161 ) ENGINE=MyISAM DEFAULT CHARSET=latin1