Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 SET sql_mode='NO_ENGINE_SUBSTITUTION';
3 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT);
4 SHOW TABLES;
5 Tables_in_test
6 t1
7 SHOW CREATE TABLE t1;
8 Table Create Table
9 t1 CREATE TABLE `t1` (
10 `c1` bit(1) NOT NULL,
11 `c2` bit(1) DEFAULT NULL
12 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
13 ALTER TABLE t1 DROP c2;
14 ALTER TABLE t1 DROP c1;
15 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
16 SHOW CREATE TABLE t1;
17 Table Create Table
18 t1 CREATE TABLE `t1` (
19 `c1` bit(1) NOT NULL
20 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
21 DROP TABLE t1;
22 SHOW TABLES;
23 Tables_in_test
24 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT);
25 SHOW TABLES;
26 Tables_in_test
27 t1
28 SHOW CREATE TABLE t1;
29 Table Create Table
30 t1 CREATE TABLE `t1` (
31 `c1` tinyint NOT NULL,
32 `c2` tinyint DEFAULT NULL
33 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
34 ALTER TABLE t1 DROP c2;
35 ALTER TABLE t1 DROP c1;
36 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
37 SHOW CREATE TABLE t1;
38 Table Create Table
39 t1 CREATE TABLE `t1` (
40 `c1` tinyint NOT NULL
41 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
42 DROP TABLE t1;
43 SHOW TABLES;
44 Tables_in_test
45 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT);
46 SHOW TABLES;
47 Tables_in_test
48 t1
49 SHOW CREATE TABLE t1;
50 Table Create Table
51 t1 CREATE TABLE `t1` (
52 `c1` smallint NOT NULL,
53 `c2` smallint DEFAULT NULL
54 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
55 ALTER TABLE t1 DROP c2;
56 ALTER TABLE t1 DROP c1;
57 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
58 SHOW CREATE TABLE t1;
59 Table Create Table
60 t1 CREATE TABLE `t1` (
61 `c1` smallint NOT NULL
62 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
63 DROP TABLE t1;
64 SHOW TABLES;
65 Tables_in_test
66 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT);
67 SHOW TABLES;
68 Tables_in_test
69 t1
70 SHOW CREATE TABLE t1;
71 Table Create Table
72 t1 CREATE TABLE `t1` (
73 `c1` mediumint NOT NULL,
74 `c2` mediumint DEFAULT NULL
75 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
76 ALTER TABLE t1 DROP c2;
77 ALTER TABLE t1 DROP c1;
78 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
79 SHOW CREATE TABLE t1;
80 Table Create Table
81 t1 CREATE TABLE `t1` (
82 `c1` mediumint NOT NULL
83 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
84 DROP TABLE t1;
85 SHOW TABLES;
86 Tables_in_test
87 CREATE TABLE t1(c1 INT NOT NULL, c2 INT);
88 SHOW TABLES;
89 Tables_in_test
90 t1
91 SHOW CREATE TABLE t1;
92 Table Create Table
93 t1 CREATE TABLE `t1` (
94 `c1` int NOT NULL,
95 `c2` int DEFAULT NULL
96 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
97 ALTER TABLE t1 DROP c2;
98 ALTER TABLE t1 DROP c1;
99 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
100 SHOW CREATE TABLE t1;
101 Table Create Table
102 t1 CREATE TABLE `t1` (
103 `c1` int NOT NULL
104 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
105 DROP TABLE t1;
106 SHOW TABLES;
107 Tables_in_test
108 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER);
109 SHOW TABLES;
110 Tables_in_test
111 t1
112 SHOW CREATE TABLE t1;
113 Table Create Table
114 t1 CREATE TABLE `t1` (
115 `c1` int NOT NULL,
116 `c2` int DEFAULT NULL
117 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
118 ALTER TABLE t1 DROP c2;
119 ALTER TABLE t1 DROP c1;
120 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
121 SHOW CREATE TABLE t1;
122 Table Create Table
123 t1 CREATE TABLE `t1` (
124 `c1` int NOT NULL
125 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
126 DROP TABLE t1;
127 SHOW TABLES;
128 Tables_in_test
129 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT);
130 SHOW TABLES;
131 Tables_in_test
132 t1
133 SHOW CREATE TABLE t1;
134 Table Create Table
135 t1 CREATE TABLE `t1` (
136 `c1` bigint NOT NULL,
137 `c2` bigint DEFAULT NULL
138 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
139 ALTER TABLE t1 DROP c2;
140 ALTER TABLE t1 DROP c1;
141 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
142 SHOW CREATE TABLE t1;
143 Table Create Table
144 t1 CREATE TABLE `t1` (
145 `c1` bigint NOT NULL
146 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
147 DROP TABLE t1;
148 SHOW TABLES;
149 Tables_in_test
150 CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL);
151 SHOW TABLES;
152 Tables_in_test
153 t1
154 SHOW CREATE TABLE t1;
155 Table Create Table
156 t1 CREATE TABLE `t1` (
157 `c1` double NOT NULL,
158 `c2` double DEFAULT NULL
159 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
160 ALTER TABLE t1 DROP c2;
161 ALTER TABLE t1 DROP c1;
162 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
163 SHOW CREATE TABLE t1;
164 Table Create Table
165 t1 CREATE TABLE `t1` (
166 `c1` double NOT NULL
167 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
168 DROP TABLE t1;
169 SHOW TABLES;
170 Tables_in_test
171 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE);
172 SHOW TABLES;
173 Tables_in_test
174 t1
175 SHOW CREATE TABLE t1;
176 Table Create Table
177 t1 CREATE TABLE `t1` (
178 `c1` double NOT NULL,
179 `c2` double DEFAULT NULL
180 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
181 ALTER TABLE t1 DROP c2;
182 ALTER TABLE t1 DROP c1;
183 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
184 SHOW CREATE TABLE t1;
185 Table Create Table
186 t1 CREATE TABLE `t1` (
187 `c1` double NOT NULL
188 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
189 DROP TABLE t1;
190 SHOW TABLES;
191 Tables_in_test
192 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT);
193 SHOW TABLES;
194 Tables_in_test
195 t1
196 SHOW CREATE TABLE t1;
197 Table Create Table
198 t1 CREATE TABLE `t1` (
199 `c1` float NOT NULL,
200 `c2` float DEFAULT NULL
201 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
202 ALTER TABLE t1 DROP c2;
203 ALTER TABLE t1 DROP c1;
204 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
205 SHOW CREATE TABLE t1;
206 Table Create Table
207 t1 CREATE TABLE `t1` (
208 `c1` float NOT NULL
209 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
210 DROP TABLE t1;
211 SHOW TABLES;
212 Tables_in_test
213 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL);
214 SHOW TABLES;
215 Tables_in_test
216 t1
217 SHOW CREATE TABLE t1;
218 Table Create Table
219 t1 CREATE TABLE `t1` (
220 `c1` decimal(10,0) NOT NULL,
221 `c2` decimal(10,0) DEFAULT NULL
222 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
223 ALTER TABLE t1 DROP c2;
224 ALTER TABLE t1 DROP c1;
225 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
226 SHOW CREATE TABLE t1;
227 Table Create Table
228 t1 CREATE TABLE `t1` (
229 `c1` decimal(10,0) NOT NULL
230 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
231 DROP TABLE t1;
232 SHOW TABLES;
233 Tables_in_test
234 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC);
235 SHOW TABLES;
236 Tables_in_test
237 t1
238 SHOW CREATE TABLE t1;
239 Table Create Table
240 t1 CREATE TABLE `t1` (
241 `c1` decimal(10,0) NOT NULL,
242 `c2` decimal(10,0) DEFAULT NULL
243 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
244 ALTER TABLE t1 DROP c2;
245 ALTER TABLE t1 DROP c1;
246 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
247 SHOW CREATE TABLE t1;
248 Table Create Table
249 t1 CREATE TABLE `t1` (
250 `c1` decimal(10,0) NOT NULL
251 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
252 DROP TABLE t1;
253 SHOW TABLES;
254 Tables_in_test
255 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE);
256 SHOW TABLES;
257 Tables_in_test
258 t1
259 SHOW CREATE TABLE t1;
260 Table Create Table
261 t1 CREATE TABLE `t1` (
262 `c1` date NOT NULL,
263 `c2` date DEFAULT NULL
264 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
265 ALTER TABLE t1 DROP c2;
266 ALTER TABLE t1 DROP c1;
267 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
268 SHOW CREATE TABLE t1;
269 Table Create Table
270 t1 CREATE TABLE `t1` (
271 `c1` date NOT NULL
272 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
273 DROP TABLE t1;
274 SHOW TABLES;
275 Tables_in_test
276 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME);
277 SHOW TABLES;
278 Tables_in_test
279 t1
280 SHOW CREATE TABLE t1;
281 Table Create Table
282 t1 CREATE TABLE `t1` (
283 `c1` time NOT NULL,
284 `c2` time DEFAULT NULL
285 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
286 ALTER TABLE t1 DROP c2;
287 ALTER TABLE t1 DROP c1;
288 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
289 SHOW CREATE TABLE t1;
290 Table Create Table
291 t1 CREATE TABLE `t1` (
292 `c1` time NOT NULL
293 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
294 DROP TABLE t1;
295 SHOW TABLES;
296 Tables_in_test
297 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP);
298 SHOW TABLES;
299 Tables_in_test
300 t1
301 SHOW CREATE TABLE t1;
302 Table Create Table
303 t1 CREATE TABLE `t1` (
304 `c1` timestamp NOT NULL,
305 `c2` timestamp NULL DEFAULT NULL
306 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
307 ALTER TABLE t1 DROP c2;
308 ALTER TABLE t1 DROP c1;
309 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
310 SHOW CREATE TABLE t1;
311 Table Create Table
312 t1 CREATE TABLE `t1` (
313 `c1` timestamp NOT NULL
314 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
315 DROP TABLE t1;
316 SHOW TABLES;
317 Tables_in_test
318 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR);
319 SHOW TABLES;
320 Tables_in_test
321 t1
322 SHOW CREATE TABLE t1;
323 Table Create Table
324 t1 CREATE TABLE `t1` (
325 `c1` year NOT NULL,
326 `c2` year DEFAULT NULL
327 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
328 ALTER TABLE t1 DROP c2;
329 ALTER TABLE t1 DROP c1;
330 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
331 SHOW CREATE TABLE t1;
332 Table Create Table
333 t1 CREATE TABLE `t1` (
334 `c1` year NOT NULL
335 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
336 DROP TABLE t1;
337 SHOW TABLES;
338 Tables_in_test
339 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT);
340 SHOW TABLES;
341 Tables_in_test
342 t1
343 SHOW CREATE TABLE t1;
344 Table Create Table
345 t1 CREATE TABLE `t1` (
346 `c1` bit(1) NOT NULL,
347 `c2` bit(1) DEFAULT NULL
348 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
349 ALTER TABLE t1 DROP COLUMN c2;
350 ALTER TABLE t1 DROP COLUMN c1;
351 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
352 SHOW CREATE TABLE t1;
353 Table Create Table
354 t1 CREATE TABLE `t1` (
355 `c1` bit(1) NOT NULL
356 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
357 DROP TABLE t1;
358 SHOW TABLES;
359 Tables_in_test
360 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT);
361 SHOW TABLES;
362 Tables_in_test
363 t1
364 SHOW CREATE TABLE t1;
365 Table Create Table
366 t1 CREATE TABLE `t1` (
367 `c1` tinyint NOT NULL,
368 `c2` tinyint DEFAULT NULL
369 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
370 ALTER TABLE t1 DROP COLUMN c2;
371 ALTER TABLE t1 DROP COLUMN c1;
372 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
373 SHOW CREATE TABLE t1;
374 Table Create Table
375 t1 CREATE TABLE `t1` (
376 `c1` tinyint NOT NULL
377 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
378 DROP TABLE t1;
379 SHOW TABLES;
380 Tables_in_test
381 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT);
382 SHOW TABLES;
383 Tables_in_test
384 t1
385 SHOW CREATE TABLE t1;
386 Table Create Table
387 t1 CREATE TABLE `t1` (
388 `c1` smallint NOT NULL,
389 `c2` smallint DEFAULT NULL
390 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
391 ALTER TABLE t1 DROP COLUMN c2;
392 ALTER TABLE t1 DROP COLUMN c1;
393 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
394 SHOW CREATE TABLE t1;
395 Table Create Table
396 t1 CREATE TABLE `t1` (
397 `c1` smallint NOT NULL
398 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
399 DROP TABLE t1;
400 SHOW TABLES;
401 Tables_in_test
402 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT);
403 SHOW TABLES;
404 Tables_in_test
405 t1
406 SHOW CREATE TABLE t1;
407 Table Create Table
408 t1 CREATE TABLE `t1` (
409 `c1` mediumint NOT NULL,
410 `c2` mediumint DEFAULT NULL
411 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
412 ALTER TABLE t1 DROP COLUMN c2;
413 ALTER TABLE t1 DROP COLUMN c1;
414 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
415 SHOW CREATE TABLE t1;
416 Table Create Table
417 t1 CREATE TABLE `t1` (
418 `c1` mediumint NOT NULL
419 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
420 DROP TABLE t1;
421 SHOW TABLES;
422 Tables_in_test
423 CREATE TABLE t1(c1 INT NOT NULL, c2 INT);
424 SHOW TABLES;
425 Tables_in_test
426 t1
427 SHOW CREATE TABLE t1;
428 Table Create Table
429 t1 CREATE TABLE `t1` (
430 `c1` int NOT NULL,
431 `c2` int DEFAULT NULL
432 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
433 ALTER TABLE t1 DROP COLUMN c2;
434 ALTER TABLE t1 DROP COLUMN c1;
435 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
436 SHOW CREATE TABLE t1;
437 Table Create Table
438 t1 CREATE TABLE `t1` (
439 `c1` int NOT NULL
440 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
441 DROP TABLE t1;
442 SHOW TABLES;
443 Tables_in_test
444 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER);
445 SHOW TABLES;
446 Tables_in_test
447 t1
448 SHOW CREATE TABLE t1;
449 Table Create Table
450 t1 CREATE TABLE `t1` (
451 `c1` int NOT NULL,
452 `c2` int DEFAULT NULL
453 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
454 ALTER TABLE t1 DROP COLUMN c2;
455 ALTER TABLE t1 DROP COLUMN c1;
456 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
457 SHOW CREATE TABLE t1;
458 Table Create Table
459 t1 CREATE TABLE `t1` (
460 `c1` int NOT NULL
461 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
462 DROP TABLE t1;
463 SHOW TABLES;
464 Tables_in_test
465 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT);
466 SHOW TABLES;
467 Tables_in_test
468 t1
469 SHOW CREATE TABLE t1;
470 Table Create Table
471 t1 CREATE TABLE `t1` (
472 `c1` bigint NOT NULL,
473 `c2` bigint DEFAULT NULL
474 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
475 ALTER TABLE t1 DROP COLUMN c2;
476 ALTER TABLE t1 DROP COLUMN c1;
477 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
478 SHOW CREATE TABLE t1;
479 Table Create Table
480 t1 CREATE TABLE `t1` (
481 `c1` bigint NOT NULL
482 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
483 DROP TABLE t1;
484 SHOW TABLES;
485 Tables_in_test
486 CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL);
487 SHOW TABLES;
488 Tables_in_test
489 t1
490 SHOW CREATE TABLE t1;
491 Table Create Table
492 t1 CREATE TABLE `t1` (
493 `c1` double NOT NULL,
494 `c2` double DEFAULT NULL
495 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
496 ALTER TABLE t1 DROP COLUMN c2;
497 ALTER TABLE t1 DROP COLUMN c1;
498 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
499 SHOW CREATE TABLE t1;
500 Table Create Table
501 t1 CREATE TABLE `t1` (
502 `c1` double NOT NULL
503 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
504 DROP TABLE t1;
505 SHOW TABLES;
506 Tables_in_test
507 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE);
508 SHOW TABLES;
509 Tables_in_test
510 t1
511 SHOW CREATE TABLE t1;
512 Table Create Table
513 t1 CREATE TABLE `t1` (
514 `c1` double NOT NULL,
515 `c2` double DEFAULT NULL
516 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
517 ALTER TABLE t1 DROP COLUMN c2;
518 ALTER TABLE t1 DROP COLUMN c1;
519 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
520 SHOW CREATE TABLE t1;
521 Table Create Table
522 t1 CREATE TABLE `t1` (
523 `c1` double NOT NULL
524 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
525 DROP TABLE t1;
526 SHOW TABLES;
527 Tables_in_test
528 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT);
529 SHOW TABLES;
530 Tables_in_test
531 t1
532 SHOW CREATE TABLE t1;
533 Table Create Table
534 t1 CREATE TABLE `t1` (
535 `c1` float NOT NULL,
536 `c2` float DEFAULT NULL
537 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
538 ALTER TABLE t1 DROP COLUMN c2;
539 ALTER TABLE t1 DROP COLUMN c1;
540 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
541 SHOW CREATE TABLE t1;
542 Table Create Table
543 t1 CREATE TABLE `t1` (
544 `c1` float NOT NULL
545 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
546 DROP TABLE t1;
547 SHOW TABLES;
548 Tables_in_test
549 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL);
550 SHOW TABLES;
551 Tables_in_test
552 t1
553 SHOW CREATE TABLE t1;
554 Table Create Table
555 t1 CREATE TABLE `t1` (
556 `c1` decimal(10,0) NOT NULL,
557 `c2` decimal(10,0) DEFAULT NULL
558 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
559 ALTER TABLE t1 DROP COLUMN c2;
560 ALTER TABLE t1 DROP COLUMN c1;
561 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
562 SHOW CREATE TABLE t1;
563 Table Create Table
564 t1 CREATE TABLE `t1` (
565 `c1` decimal(10,0) NOT NULL
566 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
567 DROP TABLE t1;
568 SHOW TABLES;
569 Tables_in_test
570 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC);
571 SHOW TABLES;
572 Tables_in_test
573 t1
574 SHOW CREATE TABLE t1;
575 Table Create Table
576 t1 CREATE TABLE `t1` (
577 `c1` decimal(10,0) NOT NULL,
578 `c2` decimal(10,0) DEFAULT NULL
579 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
580 ALTER TABLE t1 DROP COLUMN c2;
581 ALTER TABLE t1 DROP COLUMN c1;
582 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
583 SHOW CREATE TABLE t1;
584 Table Create Table
585 t1 CREATE TABLE `t1` (
586 `c1` decimal(10,0) NOT NULL
587 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
588 DROP TABLE t1;
589 SHOW TABLES;
590 Tables_in_test
591 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE);
592 SHOW TABLES;
593 Tables_in_test
594 t1
595 SHOW CREATE TABLE t1;
596 Table Create Table
597 t1 CREATE TABLE `t1` (
598 `c1` date NOT NULL,
599 `c2` date DEFAULT NULL
600 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
601 ALTER TABLE t1 DROP COLUMN c2;
602 ALTER TABLE t1 DROP COLUMN c1;
603 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
604 SHOW CREATE TABLE t1;
605 Table Create Table
606 t1 CREATE TABLE `t1` (
607 `c1` date NOT NULL
608 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
609 DROP TABLE t1;
610 SHOW TABLES;
611 Tables_in_test
612 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME);
613 SHOW TABLES;
614 Tables_in_test
615 t1
616 SHOW CREATE TABLE t1;
617 Table Create Table
618 t1 CREATE TABLE `t1` (
619 `c1` time NOT NULL,
620 `c2` time DEFAULT NULL
621 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
622 ALTER TABLE t1 DROP COLUMN c2;
623 ALTER TABLE t1 DROP COLUMN c1;
624 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
625 SHOW CREATE TABLE t1;
626 Table Create Table
627 t1 CREATE TABLE `t1` (
628 `c1` time NOT NULL
629 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
630 DROP TABLE t1;
631 SHOW TABLES;
632 Tables_in_test
633 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP);
634 SHOW TABLES;
635 Tables_in_test
636 t1
637 SHOW CREATE TABLE t1;
638 Table Create Table
639 t1 CREATE TABLE `t1` (
640 `c1` timestamp NOT NULL,
641 `c2` timestamp NULL DEFAULT NULL
642 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
643 ALTER TABLE t1 DROP COLUMN c2;
644 ALTER TABLE t1 DROP COLUMN c1;
645 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
646 SHOW CREATE TABLE t1;
647 Table Create Table
648 t1 CREATE TABLE `t1` (
649 `c1` timestamp NOT NULL
650 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
651 DROP TABLE t1;
652 SHOW TABLES;
653 Tables_in_test
654 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR);
655 SHOW TABLES;
656 Tables_in_test
657 t1
658 SHOW CREATE TABLE t1;
659 Table Create Table
660 t1 CREATE TABLE `t1` (
661 `c1` year NOT NULL,
662 `c2` year DEFAULT NULL
663 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
664 ALTER TABLE t1 DROP COLUMN c2;
665 ALTER TABLE t1 DROP COLUMN c1;
666 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
667 SHOW CREATE TABLE t1;
668 Table Create Table
669 t1 CREATE TABLE `t1` (
670 `c1` year NOT NULL
671 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
672 DROP TABLE t1;
673 SHOW TABLES;
674 Tables_in_test
675 SET sql_mode=default;