Debian Codegraph @

mysql-test/suite/engines/funcs/r/tc_structure_create_like.result

raw
1 DROP TABLE IF EXISTS src,dest;
2 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BIT NULL, PRIMARY KEY(c1));
3 CREATE TABLE dst LIKE src;
4 SHOW TABLES;
5 Tables_in_test
6 dst
7 src
8 SHOW CREATE TABLE dst;
9 Table Create Table
10 dst CREATE TABLE `dst` (
11 `c1` int NOT NULL AUTO_INCREMENT,
12 `c2` bit(1) DEFAULT NULL,
13 PRIMARY KEY (`c1`)
14 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
15 DROP TABLE dst;
16 SHOW TABLES;
17 Tables_in_test
18 src
19 DROP TABLE src;
20 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYINT NULL, PRIMARY KEY(c1));
21 CREATE TABLE dst LIKE src;
22 SHOW TABLES;
23 Tables_in_test
24 dst
25 src
26 SHOW CREATE TABLE dst;
27 Table Create Table
28 dst CREATE TABLE `dst` (
29 `c1` int NOT NULL AUTO_INCREMENT,
30 `c2` tinyint DEFAULT NULL,
31 PRIMARY KEY (`c1`)
32 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
33 DROP TABLE dst;
34 SHOW TABLES;
35 Tables_in_test
36 src
37 DROP TABLE src;
38 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 SMALLINT NULL, PRIMARY KEY(c1));
39 CREATE TABLE dst LIKE src;
40 SHOW TABLES;
41 Tables_in_test
42 dst
43 src
44 SHOW CREATE TABLE dst;
45 Table Create Table
46 dst CREATE TABLE `dst` (
47 `c1` int NOT NULL AUTO_INCREMENT,
48 `c2` smallint DEFAULT NULL,
49 PRIMARY KEY (`c1`)
50 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
51 DROP TABLE dst;
52 SHOW TABLES;
53 Tables_in_test
54 src
55 DROP TABLE src;
56 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMINT NULL, PRIMARY KEY(c1));
57 CREATE TABLE dst LIKE src;
58 SHOW TABLES;
59 Tables_in_test
60 dst
61 src
62 SHOW CREATE TABLE dst;
63 Table Create Table
64 dst CREATE TABLE `dst` (
65 `c1` int NOT NULL AUTO_INCREMENT,
66 `c2` mediumint DEFAULT NULL,
67 PRIMARY KEY (`c1`)
68 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
69 DROP TABLE dst;
70 SHOW TABLES;
71 Tables_in_test
72 src
73 DROP TABLE src;
74 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 INT NULL, PRIMARY KEY(c1));
75 CREATE TABLE dst LIKE src;
76 SHOW TABLES;
77 Tables_in_test
78 dst
79 src
80 SHOW CREATE TABLE dst;
81 Table Create Table
82 dst CREATE TABLE `dst` (
83 `c1` int NOT NULL AUTO_INCREMENT,
84 `c2` int DEFAULT NULL,
85 PRIMARY KEY (`c1`)
86 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
87 DROP TABLE dst;
88 SHOW TABLES;
89 Tables_in_test
90 src
91 DROP TABLE src;
92 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 INTEGER NULL, PRIMARY KEY(c1));
93 CREATE TABLE dst LIKE src;
94 SHOW TABLES;
95 Tables_in_test
96 dst
97 src
98 SHOW CREATE TABLE dst;
99 Table Create Table
100 dst CREATE TABLE `dst` (
101 `c1` int NOT NULL AUTO_INCREMENT,
102 `c2` int DEFAULT NULL,
103 PRIMARY KEY (`c1`)
104 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
105 DROP TABLE dst;
106 SHOW TABLES;
107 Tables_in_test
108 src
109 DROP TABLE src;
110 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BIGINT NULL, PRIMARY KEY(c1));
111 CREATE TABLE dst LIKE src;
112 SHOW TABLES;
113 Tables_in_test
114 dst
115 src
116 SHOW CREATE TABLE dst;
117 Table Create Table
118 dst CREATE TABLE `dst` (
119 `c1` int NOT NULL AUTO_INCREMENT,
120 `c2` bigint DEFAULT NULL,
121 PRIMARY KEY (`c1`)
122 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
123 DROP TABLE dst;
124 SHOW TABLES;
125 Tables_in_test
126 src
127 DROP TABLE src;
128 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 REAL NULL, PRIMARY KEY(c1));
129 CREATE TABLE dst LIKE src;
130 SHOW TABLES;
131 Tables_in_test
132 dst
133 src
134 SHOW CREATE TABLE dst;
135 Table Create Table
136 dst CREATE TABLE `dst` (
137 `c1` int NOT NULL AUTO_INCREMENT,
138 `c2` double DEFAULT NULL,
139 PRIMARY KEY (`c1`)
140 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
141 DROP TABLE dst;
142 SHOW TABLES;
143 Tables_in_test
144 src
145 DROP TABLE src;
146 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DOUBLE NULL, PRIMARY KEY(c1));
147 CREATE TABLE dst LIKE src;
148 SHOW TABLES;
149 Tables_in_test
150 dst
151 src
152 SHOW CREATE TABLE dst;
153 Table Create Table
154 dst CREATE TABLE `dst` (
155 `c1` int NOT NULL AUTO_INCREMENT,
156 `c2` double DEFAULT NULL,
157 PRIMARY KEY (`c1`)
158 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
159 DROP TABLE dst;
160 SHOW TABLES;
161 Tables_in_test
162 src
163 DROP TABLE src;
164 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 FLOAT NULL, PRIMARY KEY(c1));
165 CREATE TABLE dst LIKE src;
166 SHOW TABLES;
167 Tables_in_test
168 dst
169 src
170 SHOW CREATE TABLE dst;
171 Table Create Table
172 dst CREATE TABLE `dst` (
173 `c1` int NOT NULL AUTO_INCREMENT,
174 `c2` float DEFAULT NULL,
175 PRIMARY KEY (`c1`)
176 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
177 DROP TABLE dst;
178 SHOW TABLES;
179 Tables_in_test
180 src
181 DROP TABLE src;
182 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DECIMAL NULL, PRIMARY KEY(c1));
183 CREATE TABLE dst LIKE src;
184 SHOW TABLES;
185 Tables_in_test
186 dst
187 src
188 SHOW CREATE TABLE dst;
189 Table Create Table
190 dst CREATE TABLE `dst` (
191 `c1` int NOT NULL AUTO_INCREMENT,
192 `c2` decimal(10,0) DEFAULT NULL,
193 PRIMARY KEY (`c1`)
194 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
195 DROP TABLE dst;
196 SHOW TABLES;
197 Tables_in_test
198 src
199 DROP TABLE src;
200 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 NUMERIC NULL, PRIMARY KEY(c1));
201 CREATE TABLE dst LIKE src;
202 SHOW TABLES;
203 Tables_in_test
204 dst
205 src
206 SHOW CREATE TABLE dst;
207 Table Create Table
208 dst CREATE TABLE `dst` (
209 `c1` int NOT NULL AUTO_INCREMENT,
210 `c2` decimal(10,0) DEFAULT NULL,
211 PRIMARY KEY (`c1`)
212 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
213 DROP TABLE dst;
214 SHOW TABLES;
215 Tables_in_test
216 src
217 DROP TABLE src;
218 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DATE NULL, PRIMARY KEY(c1));
219 CREATE TABLE dst LIKE src;
220 SHOW TABLES;
221 Tables_in_test
222 dst
223 src
224 SHOW CREATE TABLE dst;
225 Table Create Table
226 dst CREATE TABLE `dst` (
227 `c1` int NOT NULL AUTO_INCREMENT,
228 `c2` date DEFAULT NULL,
229 PRIMARY KEY (`c1`)
230 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
231 DROP TABLE dst;
232 SHOW TABLES;
233 Tables_in_test
234 src
235 DROP TABLE src;
236 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TIME NULL, PRIMARY KEY(c1));
237 CREATE TABLE dst LIKE src;
238 SHOW TABLES;
239 Tables_in_test
240 dst
241 src
242 SHOW CREATE TABLE dst;
243 Table Create Table
244 dst CREATE TABLE `dst` (
245 `c1` int NOT NULL AUTO_INCREMENT,
246 `c2` time DEFAULT NULL,
247 PRIMARY KEY (`c1`)
248 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
249 DROP TABLE dst;
250 SHOW TABLES;
251 Tables_in_test
252 src
253 DROP TABLE src;
254 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DATETIME NULL, PRIMARY KEY(c1));
255 CREATE TABLE dst LIKE src;
256 SHOW TABLES;
257 Tables_in_test
258 dst
259 src
260 SHOW CREATE TABLE dst;
261 Table Create Table
262 dst CREATE TABLE `dst` (
263 `c1` int NOT NULL AUTO_INCREMENT,
264 `c2` datetime DEFAULT NULL,
265 PRIMARY KEY (`c1`)
266 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
267 DROP TABLE dst;
268 SHOW TABLES;
269 Tables_in_test
270 src
271 DROP TABLE src;
272 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TIMESTAMP NULL, PRIMARY KEY(c1));
273 CREATE TABLE dst LIKE src;
274 SHOW TABLES;
275 Tables_in_test
276 dst
277 src
278 SHOW CREATE TABLE dst;
279 Table Create Table
280 dst CREATE TABLE `dst` (
281 `c1` int NOT NULL AUTO_INCREMENT,
282 `c2` timestamp NULL DEFAULT NULL,
283 PRIMARY KEY (`c1`)
284 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
285 DROP TABLE dst;
286 SHOW TABLES;
287 Tables_in_test
288 src
289 DROP TABLE src;
290 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 YEAR NULL, PRIMARY KEY(c1));
291 CREATE TABLE dst LIKE src;
292 SHOW TABLES;
293 Tables_in_test
294 dst
295 src
296 SHOW CREATE TABLE dst;
297 Table Create Table
298 dst CREATE TABLE `dst` (
299 `c1` int NOT NULL AUTO_INCREMENT,
300 `c2` year DEFAULT NULL,
301 PRIMARY KEY (`c1`)
302 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
303 DROP TABLE dst;
304 SHOW TABLES;
305 Tables_in_test
306 src
307 DROP TABLE src;
308 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYBLOB NULL, PRIMARY KEY(c1));
309 CREATE TABLE dst LIKE src;
310 SHOW TABLES;
311 Tables_in_test
312 dst
313 src
314 SHOW CREATE TABLE dst;
315 Table Create Table
316 dst CREATE TABLE `dst` (
317 `c1` int NOT NULL AUTO_INCREMENT,
318 `c2` tinyblob,
319 PRIMARY KEY (`c1`)
320 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
321 DROP TABLE dst;
322 SHOW TABLES;
323 Tables_in_test
324 src
325 DROP TABLE src;
326 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BLOB NULL, PRIMARY KEY(c1));
327 CREATE TABLE dst LIKE src;
328 SHOW TABLES;
329 Tables_in_test
330 dst
331 src
332 SHOW CREATE TABLE dst;
333 Table Create Table
334 dst CREATE TABLE `dst` (
335 `c1` int NOT NULL AUTO_INCREMENT,
336 `c2` blob,
337 PRIMARY KEY (`c1`)
338 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
339 DROP TABLE dst;
340 SHOW TABLES;
341 Tables_in_test
342 src
343 DROP TABLE src;
344 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMBLOB NULL, PRIMARY KEY(c1));
345 CREATE TABLE dst LIKE src;
346 SHOW TABLES;
347 Tables_in_test
348 dst
349 src
350 SHOW CREATE TABLE dst;
351 Table Create Table
352 dst CREATE TABLE `dst` (
353 `c1` int NOT NULL AUTO_INCREMENT,
354 `c2` mediumblob,
355 PRIMARY KEY (`c1`)
356 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
357 DROP TABLE dst;
358 SHOW TABLES;
359 Tables_in_test
360 src
361 DROP TABLE src;
362 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 LONGBLOB NULL, PRIMARY KEY(c1));
363 CREATE TABLE dst LIKE src;
364 SHOW TABLES;
365 Tables_in_test
366 dst
367 src
368 SHOW CREATE TABLE dst;
369 Table Create Table
370 dst CREATE TABLE `dst` (
371 `c1` int NOT NULL AUTO_INCREMENT,
372 `c2` longblob,
373 PRIMARY KEY (`c1`)
374 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
375 DROP TABLE dst;
376 SHOW TABLES;
377 Tables_in_test
378 src
379 DROP TABLE src;
380 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYTEXT NULL, PRIMARY KEY(c1));
381 CREATE TABLE dst LIKE src;
382 SHOW TABLES;
383 Tables_in_test
384 dst
385 src
386 SHOW CREATE TABLE dst;
387 Table Create Table
388 dst CREATE TABLE `dst` (
389 `c1` int NOT NULL AUTO_INCREMENT,
390 `c2` tinytext,
391 PRIMARY KEY (`c1`)
392 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
393 DROP TABLE dst;
394 SHOW TABLES;
395 Tables_in_test
396 src
397 DROP TABLE src;
398 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TEXT NULL, PRIMARY KEY(c1));
399 CREATE TABLE dst LIKE src;
400 SHOW TABLES;
401 Tables_in_test
402 dst
403 src
404 SHOW CREATE TABLE dst;
405 Table Create Table
406 dst CREATE TABLE `dst` (
407 `c1` int NOT NULL AUTO_INCREMENT,
408 `c2` text,
409 PRIMARY KEY (`c1`)
410 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
411 DROP TABLE dst;
412 SHOW TABLES;
413 Tables_in_test
414 src
415 DROP TABLE src;
416 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMTEXT NULL, PRIMARY KEY(c1));
417 CREATE TABLE dst LIKE src;
418 SHOW TABLES;
419 Tables_in_test
420 dst
421 src
422 SHOW CREATE TABLE dst;
423 Table Create Table
424 dst CREATE TABLE `dst` (
425 `c1` int NOT NULL AUTO_INCREMENT,
426 `c2` mediumtext,
427 PRIMARY KEY (`c1`)
428 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
429 DROP TABLE dst;
430 SHOW TABLES;
431 Tables_in_test
432 src
433 DROP TABLE src;
434 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 LONGTEXT NULL, PRIMARY KEY(c1));
435 CREATE TABLE dst LIKE src;
436 SHOW TABLES;
437 Tables_in_test
438 dst
439 src
440 SHOW CREATE TABLE dst;
441 Table Create Table
442 dst CREATE TABLE `dst` (
443 `c1` int NOT NULL AUTO_INCREMENT,
444 `c2` longtext,
445 PRIMARY KEY (`c1`)
446 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
447 DROP TABLE dst;
448 SHOW TABLES;
449 Tables_in_test
450 src
451 DROP TABLE src;