1DROP TABLE IF EXISTS t1,t2;
2connect  con1,localhost,root,,;
3connect  con2,localhost,root,,;
4CREATE TABLE t1 (x1 INT);
5connection con1;
6ALTER TABLE t1 CHANGE x1 x2 INT;
7connection con2;
8CREATE TABLE t2 LIKE t1;
9SHOW CREATE TABLE t2;
10Table	Create Table
11t2	CREATE TABLE `t2` (
12  `xx` int(11) DEFAULT NULL
13) ENGINE=MyISAM DEFAULT CHARSET=latin1
14DROP TABLE t2;
15connection con1;
16ALTER TABLE t1 CHANGE x2 x1 INT;
17connection con2;
18CREATE TABLE t2 LIKE t1;
19SHOW CREATE TABLE t2;
20Table	Create Table
21t2	CREATE TABLE `t2` (
22  `xx` int(11) DEFAULT NULL
23) ENGINE=MyISAM DEFAULT CHARSET=latin1
24DROP TABLE t2;
25connection con1;
26connection con1;
27ALTER TABLE t1 CHANGE x1 x2 INT;
28connection con2;
29CREATE TABLE t2 LIKE t1;
30SHOW CREATE TABLE t2;
31Table	Create Table
32t2	CREATE TABLE `t2` (
33  `xx` int(11) DEFAULT NULL
34) ENGINE=MyISAM DEFAULT CHARSET=latin1
35DROP TABLE t2;
36connection con1;
37ALTER TABLE t1 CHANGE x2 x1 INT;
38connection con2;
39CREATE TABLE t2 LIKE t1;
40SHOW CREATE TABLE t2;
41Table	Create Table
42t2	CREATE TABLE `t2` (
43  `xx` int(11) DEFAULT NULL
44) ENGINE=MyISAM DEFAULT CHARSET=latin1
45DROP TABLE t2;
46connection con1;
47connection con1;
48ALTER TABLE t1 CHANGE x1 x2 INT;
49connection con2;
50CREATE TABLE t2 LIKE t1;
51SHOW CREATE TABLE t2;
52Table	Create Table
53t2	CREATE TABLE `t2` (
54  `xx` int(11) DEFAULT NULL
55) ENGINE=MyISAM DEFAULT CHARSET=latin1
56DROP TABLE t2;
57connection con1;
58ALTER TABLE t1 CHANGE x2 x1 INT;
59connection con2;
60CREATE TABLE t2 LIKE t1;
61SHOW CREATE TABLE t2;
62Table	Create Table
63t2	CREATE TABLE `t2` (
64  `xx` int(11) DEFAULT NULL
65) ENGINE=MyISAM DEFAULT CHARSET=latin1
66DROP TABLE t2;
67connection con1;
68connection con1;
69ALTER TABLE t1 CHANGE x1 x2 INT;
70connection con2;
71CREATE TABLE t2 LIKE t1;
72SHOW CREATE TABLE t2;
73Table	Create Table
74t2	CREATE TABLE `t2` (
75  `xx` int(11) DEFAULT NULL
76) ENGINE=MyISAM DEFAULT CHARSET=latin1
77DROP TABLE t2;
78connection con1;
79ALTER TABLE t1 CHANGE x2 x1 INT;
80connection con2;
81CREATE TABLE t2 LIKE t1;
82SHOW CREATE TABLE t2;
83Table	Create Table
84t2	CREATE TABLE `t2` (
85  `xx` int(11) DEFAULT NULL
86) ENGINE=MyISAM DEFAULT CHARSET=latin1
87DROP TABLE t2;
88connection con1;
89connection con1;
90ALTER TABLE t1 CHANGE x1 x2 INT;
91connection con2;
92CREATE TABLE t2 LIKE t1;
93SHOW CREATE TABLE t2;
94Table	Create Table
95t2	CREATE TABLE `t2` (
96  `xx` int(11) DEFAULT NULL
97) ENGINE=MyISAM DEFAULT CHARSET=latin1
98DROP TABLE t2;
99connection con1;
100ALTER TABLE t1 CHANGE x2 x1 INT;
101connection con2;
102CREATE TABLE t2 LIKE t1;
103SHOW CREATE TABLE t2;
104Table	Create Table
105t2	CREATE TABLE `t2` (
106  `xx` int(11) DEFAULT NULL
107) ENGINE=MyISAM DEFAULT CHARSET=latin1
108DROP TABLE t2;
109connection con1;
110connection con1;
111ALTER TABLE t1 CHANGE x1 x2 INT;
112connection con2;
113CREATE TABLE t2 LIKE t1;
114SHOW CREATE TABLE t2;
115Table	Create Table
116t2	CREATE TABLE `t2` (
117  `xx` int(11) DEFAULT NULL
118) ENGINE=MyISAM DEFAULT CHARSET=latin1
119DROP TABLE t2;
120connection con1;
121ALTER TABLE t1 CHANGE x2 x1 INT;
122connection con2;
123CREATE TABLE t2 LIKE t1;
124SHOW CREATE TABLE t2;
125Table	Create Table
126t2	CREATE TABLE `t2` (
127  `xx` int(11) DEFAULT NULL
128) ENGINE=MyISAM DEFAULT CHARSET=latin1
129DROP TABLE t2;
130connection con1;
131connection con1;
132ALTER TABLE t1 CHANGE x1 x2 INT;
133connection con2;
134CREATE TABLE t2 LIKE t1;
135SHOW CREATE TABLE t2;
136Table	Create Table
137t2	CREATE TABLE `t2` (
138  `xx` int(11) DEFAULT NULL
139) ENGINE=MyISAM DEFAULT CHARSET=latin1
140DROP TABLE t2;
141connection con1;
142ALTER TABLE t1 CHANGE x2 x1 INT;
143connection con2;
144CREATE TABLE t2 LIKE t1;
145SHOW CREATE TABLE t2;
146Table	Create Table
147t2	CREATE TABLE `t2` (
148  `xx` int(11) DEFAULT NULL
149) ENGINE=MyISAM DEFAULT CHARSET=latin1
150DROP TABLE t2;
151connection con1;
152connection con1;
153ALTER TABLE t1 CHANGE x1 x2 INT;
154connection con2;
155CREATE TABLE t2 LIKE t1;
156SHOW CREATE TABLE t2;
157Table	Create Table
158t2	CREATE TABLE `t2` (
159  `xx` int(11) DEFAULT NULL
160) ENGINE=MyISAM DEFAULT CHARSET=latin1
161DROP TABLE t2;
162connection con1;
163ALTER TABLE t1 CHANGE x2 x1 INT;
164connection con2;
165CREATE TABLE t2 LIKE t1;
166SHOW CREATE TABLE t2;
167Table	Create Table
168t2	CREATE TABLE `t2` (
169  `xx` int(11) DEFAULT NULL
170) ENGINE=MyISAM DEFAULT CHARSET=latin1
171DROP TABLE t2;
172connection con1;
173connection con1;
174ALTER TABLE t1 CHANGE x1 x2 INT;
175connection con2;
176CREATE TABLE t2 LIKE t1;
177SHOW CREATE TABLE t2;
178Table	Create Table
179t2	CREATE TABLE `t2` (
180  `xx` int(11) DEFAULT NULL
181) ENGINE=MyISAM DEFAULT CHARSET=latin1
182DROP TABLE t2;
183connection con1;
184ALTER TABLE t1 CHANGE x2 x1 INT;
185connection con2;
186CREATE TABLE t2 LIKE t1;
187SHOW CREATE TABLE t2;
188Table	Create Table
189t2	CREATE TABLE `t2` (
190  `xx` int(11) DEFAULT NULL
191) ENGINE=MyISAM DEFAULT CHARSET=latin1
192DROP TABLE t2;
193connection con1;
194connection con1;
195ALTER TABLE t1 CHANGE x1 x2 INT;
196connection con2;
197CREATE TABLE t2 LIKE t1;
198SHOW CREATE TABLE t2;
199Table	Create Table
200t2	CREATE TABLE `t2` (
201  `xx` int(11) DEFAULT NULL
202) ENGINE=MyISAM DEFAULT CHARSET=latin1
203DROP TABLE t2;
204connection con1;
205ALTER TABLE t1 CHANGE x2 x1 INT;
206connection con2;
207CREATE TABLE t2 LIKE t1;
208SHOW CREATE TABLE t2;
209Table	Create Table
210t2	CREATE TABLE `t2` (
211  `xx` int(11) DEFAULT NULL
212) ENGINE=MyISAM DEFAULT CHARSET=latin1
213DROP TABLE t2;
214connection con1;
215DROP TABLE t1;
216connection default;
217disconnect con1;
218disconnect con2;
219