Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t4;
2 CREATE TABLE t4(c1 TINYINT ZEROFILL NULL);
3 Warnings:
4 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
5 SHOW TABLES;
6 Tables_in_test
7 t4
8 SHOW CREATE TABLE t4;
9 Table Create Table
10 t4 CREATE TABLE `t4` (
11 `c1` tinyint(3) unsigned zerofill DEFAULT NULL
12 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
13 ALTER TABLE t4 MODIFY c1 TINYINT NULL;
14 SHOW TABLES;
15 Tables_in_test
16 t4
17 SHOW CREATE TABLE t4;
18 Table Create Table
19 t4 CREATE TABLE `t4` (
20 `c1` tinyint DEFAULT NULL
21 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
22 DROP TABLE t4;
23 SHOW TABLES;
24 Tables_in_test
25 CREATE TABLE t4(c1 SMALLINT ZEROFILL NULL);
26 Warnings:
27 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
28 SHOW TABLES;
29 Tables_in_test
30 t4
31 SHOW CREATE TABLE t4;
32 Table Create Table
33 t4 CREATE TABLE `t4` (
34 `c1` smallint(5) unsigned zerofill DEFAULT NULL
35 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
36 ALTER TABLE t4 MODIFY c1 SMALLINT NULL;
37 SHOW TABLES;
38 Tables_in_test
39 t4
40 SHOW CREATE TABLE t4;
41 Table Create Table
42 t4 CREATE TABLE `t4` (
43 `c1` smallint DEFAULT NULL
44 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
45 DROP TABLE t4;
46 SHOW TABLES;
47 Tables_in_test
48 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NULL);
49 Warnings:
50 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
51 SHOW TABLES;
52 Tables_in_test
53 t4
54 SHOW CREATE TABLE t4;
55 Table Create Table
56 t4 CREATE TABLE `t4` (
57 `c1` mediumint(8) unsigned zerofill DEFAULT NULL
58 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
59 ALTER TABLE t4 MODIFY c1 MEDIUMINT NULL;
60 SHOW TABLES;
61 Tables_in_test
62 t4
63 SHOW CREATE TABLE t4;
64 Table Create Table
65 t4 CREATE TABLE `t4` (
66 `c1` mediumint DEFAULT NULL
67 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
68 DROP TABLE t4;
69 SHOW TABLES;
70 Tables_in_test
71 CREATE TABLE t4(c1 INT ZEROFILL NULL);
72 Warnings:
73 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
74 SHOW TABLES;
75 Tables_in_test
76 t4
77 SHOW CREATE TABLE t4;
78 Table Create Table
79 t4 CREATE TABLE `t4` (
80 `c1` int(10) unsigned zerofill DEFAULT NULL
81 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
82 ALTER TABLE t4 MODIFY c1 INT NULL;
83 SHOW TABLES;
84 Tables_in_test
85 t4
86 SHOW CREATE TABLE t4;
87 Table Create Table
88 t4 CREATE TABLE `t4` (
89 `c1` int DEFAULT NULL
90 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
91 DROP TABLE t4;
92 SHOW TABLES;
93 Tables_in_test
94 CREATE TABLE t4(c1 INTEGER ZEROFILL NULL);
95 Warnings:
96 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
97 SHOW TABLES;
98 Tables_in_test
99 t4
100 SHOW CREATE TABLE t4;
101 Table Create Table
102 t4 CREATE TABLE `t4` (
103 `c1` int(10) unsigned zerofill DEFAULT NULL
104 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
105 ALTER TABLE t4 MODIFY c1 INTEGER NULL;
106 SHOW TABLES;
107 Tables_in_test
108 t4
109 SHOW CREATE TABLE t4;
110 Table Create Table
111 t4 CREATE TABLE `t4` (
112 `c1` int DEFAULT NULL
113 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
114 DROP TABLE t4;
115 SHOW TABLES;
116 Tables_in_test
117 CREATE TABLE t4(c1 BIGINT ZEROFILL NULL);
118 Warnings:
119 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
120 SHOW TABLES;
121 Tables_in_test
122 t4
123 SHOW CREATE TABLE t4;
124 Table Create Table
125 t4 CREATE TABLE `t4` (
126 `c1` bigint(20) unsigned zerofill DEFAULT NULL
127 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
128 ALTER TABLE t4 MODIFY c1 BIGINT NULL;
129 SHOW TABLES;
130 Tables_in_test
131 t4
132 SHOW CREATE TABLE t4;
133 Table Create Table
134 t4 CREATE TABLE `t4` (
135 `c1` bigint DEFAULT NULL
136 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
137 DROP TABLE t4;
138 SHOW TABLES;
139 Tables_in_test
140 CREATE TABLE t4(c1 REAL ZEROFILL NULL);
141 Warnings:
142 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
143 SHOW TABLES;
144 Tables_in_test
145 t4
146 SHOW CREATE TABLE t4;
147 Table Create Table
148 t4 CREATE TABLE `t4` (
149 `c1` double unsigned zerofill DEFAULT NULL
150 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
151 ALTER TABLE t4 MODIFY c1 REAL NULL;
152 SHOW TABLES;
153 Tables_in_test
154 t4
155 SHOW CREATE TABLE t4;
156 Table Create Table
157 t4 CREATE TABLE `t4` (
158 `c1` double DEFAULT NULL
159 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
160 DROP TABLE t4;
161 SHOW TABLES;
162 Tables_in_test
163 CREATE TABLE t4(c1 DOUBLE ZEROFILL NULL);
164 Warnings:
165 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
166 SHOW TABLES;
167 Tables_in_test
168 t4
169 SHOW CREATE TABLE t4;
170 Table Create Table
171 t4 CREATE TABLE `t4` (
172 `c1` double unsigned zerofill DEFAULT NULL
173 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
174 ALTER TABLE t4 MODIFY c1 DOUBLE NULL;
175 SHOW TABLES;
176 Tables_in_test
177 t4
178 SHOW CREATE TABLE t4;
179 Table Create Table
180 t4 CREATE TABLE `t4` (
181 `c1` double DEFAULT NULL
182 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
183 DROP TABLE t4;
184 SHOW TABLES;
185 Tables_in_test
186 CREATE TABLE t4(c1 FLOAT ZEROFILL NULL);
187 Warnings:
188 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
189 SHOW TABLES;
190 Tables_in_test
191 t4
192 SHOW CREATE TABLE t4;
193 Table Create Table
194 t4 CREATE TABLE `t4` (
195 `c1` float unsigned zerofill DEFAULT NULL
196 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
197 ALTER TABLE t4 MODIFY c1 FLOAT NULL;
198 SHOW TABLES;
199 Tables_in_test
200 t4
201 SHOW CREATE TABLE t4;
202 Table Create Table
203 t4 CREATE TABLE `t4` (
204 `c1` float DEFAULT NULL
205 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
206 DROP TABLE t4;
207 SHOW TABLES;
208 Tables_in_test
209 CREATE TABLE t4(c1 DECIMAL ZEROFILL NULL);
210 Warnings:
211 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
212 SHOW TABLES;
213 Tables_in_test
214 t4
215 SHOW CREATE TABLE t4;
216 Table Create Table
217 t4 CREATE TABLE `t4` (
218 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
219 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
220 ALTER TABLE t4 MODIFY c1 DECIMAL NULL;
221 SHOW TABLES;
222 Tables_in_test
223 t4
224 SHOW CREATE TABLE t4;
225 Table Create Table
226 t4 CREATE TABLE `t4` (
227 `c1` decimal(10,0) DEFAULT NULL
228 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
229 DROP TABLE t4;
230 SHOW TABLES;
231 Tables_in_test
232 CREATE TABLE t4(c1 NUMERIC ZEROFILL NULL);
233 Warnings:
234 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
235 SHOW TABLES;
236 Tables_in_test
237 t4
238 SHOW CREATE TABLE t4;
239 Table Create Table
240 t4 CREATE TABLE `t4` (
241 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
242 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
243 ALTER TABLE t4 MODIFY c1 NUMERIC NULL;
244 SHOW TABLES;
245 Tables_in_test
246 t4
247 SHOW CREATE TABLE t4;
248 Table Create Table
249 t4 CREATE TABLE `t4` (
250 `c1` decimal(10,0) DEFAULT NULL
251 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
252 DROP TABLE t4;
253 SHOW TABLES;
254 Tables_in_test
255 CREATE TABLE t4(c1 TINYINT ZEROFILL NULL);
256 Warnings:
257 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
258 SHOW TABLES;
259 Tables_in_test
260 t4
261 SHOW CREATE TABLE t4;
262 Table Create Table
263 t4 CREATE TABLE `t4` (
264 `c1` tinyint(3) unsigned zerofill DEFAULT NULL
265 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
266 ALTER TABLE t4 CHANGE c1 c1 TINYINT NULL;
267 SHOW TABLES;
268 Tables_in_test
269 t4
270 SHOW CREATE TABLE t4;
271 Table Create Table
272 t4 CREATE TABLE `t4` (
273 `c1` tinyint DEFAULT NULL
274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
275 DROP TABLE t4;
276 SHOW TABLES;
277 Tables_in_test
278 CREATE TABLE t4(c1 SMALLINT ZEROFILL NULL);
279 Warnings:
280 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
281 SHOW TABLES;
282 Tables_in_test
283 t4
284 SHOW CREATE TABLE t4;
285 Table Create Table
286 t4 CREATE TABLE `t4` (
287 `c1` smallint(5) unsigned zerofill DEFAULT NULL
288 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
289 ALTER TABLE t4 CHANGE c1 c1 SMALLINT NULL;
290 SHOW TABLES;
291 Tables_in_test
292 t4
293 SHOW CREATE TABLE t4;
294 Table Create Table
295 t4 CREATE TABLE `t4` (
296 `c1` smallint DEFAULT NULL
297 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
298 DROP TABLE t4;
299 SHOW TABLES;
300 Tables_in_test
301 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NULL);
302 Warnings:
303 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
304 SHOW TABLES;
305 Tables_in_test
306 t4
307 SHOW CREATE TABLE t4;
308 Table Create Table
309 t4 CREATE TABLE `t4` (
310 `c1` mediumint(8) unsigned zerofill DEFAULT NULL
311 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
312 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT NULL;
313 SHOW TABLES;
314 Tables_in_test
315 t4
316 SHOW CREATE TABLE t4;
317 Table Create Table
318 t4 CREATE TABLE `t4` (
319 `c1` mediumint DEFAULT NULL
320 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
321 DROP TABLE t4;
322 SHOW TABLES;
323 Tables_in_test
324 CREATE TABLE t4(c1 INT ZEROFILL NULL);
325 Warnings:
326 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
327 SHOW TABLES;
328 Tables_in_test
329 t4
330 SHOW CREATE TABLE t4;
331 Table Create Table
332 t4 CREATE TABLE `t4` (
333 `c1` int(10) unsigned zerofill DEFAULT NULL
334 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
335 ALTER TABLE t4 CHANGE c1 c1 INT NULL;
336 SHOW TABLES;
337 Tables_in_test
338 t4
339 SHOW CREATE TABLE t4;
340 Table Create Table
341 t4 CREATE TABLE `t4` (
342 `c1` int DEFAULT NULL
343 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
344 DROP TABLE t4;
345 SHOW TABLES;
346 Tables_in_test
347 CREATE TABLE t4(c1 INTEGER ZEROFILL NULL);
348 Warnings:
349 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
350 SHOW TABLES;
351 Tables_in_test
352 t4
353 SHOW CREATE TABLE t4;
354 Table Create Table
355 t4 CREATE TABLE `t4` (
356 `c1` int(10) unsigned zerofill DEFAULT NULL
357 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
358 ALTER TABLE t4 CHANGE c1 c1 INTEGER NULL;
359 SHOW TABLES;
360 Tables_in_test
361 t4
362 SHOW CREATE TABLE t4;
363 Table Create Table
364 t4 CREATE TABLE `t4` (
365 `c1` int DEFAULT NULL
366 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
367 DROP TABLE t4;
368 SHOW TABLES;
369 Tables_in_test
370 CREATE TABLE t4(c1 BIGINT ZEROFILL NULL);
371 Warnings:
372 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
373 SHOW TABLES;
374 Tables_in_test
375 t4
376 SHOW CREATE TABLE t4;
377 Table Create Table
378 t4 CREATE TABLE `t4` (
379 `c1` bigint(20) unsigned zerofill DEFAULT NULL
380 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
381 ALTER TABLE t4 CHANGE c1 c1 BIGINT NULL;
382 SHOW TABLES;
383 Tables_in_test
384 t4
385 SHOW CREATE TABLE t4;
386 Table Create Table
387 t4 CREATE TABLE `t4` (
388 `c1` bigint DEFAULT NULL
389 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
390 DROP TABLE t4;
391 SHOW TABLES;
392 Tables_in_test
393 CREATE TABLE t4(c1 REAL ZEROFILL NULL);
394 Warnings:
395 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
396 SHOW TABLES;
397 Tables_in_test
398 t4
399 SHOW CREATE TABLE t4;
400 Table Create Table
401 t4 CREATE TABLE `t4` (
402 `c1` double unsigned zerofill DEFAULT NULL
403 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
404 ALTER TABLE t4 CHANGE c1 c1 REAL NULL;
405 SHOW TABLES;
406 Tables_in_test
407 t4
408 SHOW CREATE TABLE t4;
409 Table Create Table
410 t4 CREATE TABLE `t4` (
411 `c1` double DEFAULT NULL
412 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
413 DROP TABLE t4;
414 SHOW TABLES;
415 Tables_in_test
416 CREATE TABLE t4(c1 DOUBLE ZEROFILL NULL);
417 Warnings:
418 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
419 SHOW TABLES;
420 Tables_in_test
421 t4
422 SHOW CREATE TABLE t4;
423 Table Create Table
424 t4 CREATE TABLE `t4` (
425 `c1` double unsigned zerofill DEFAULT NULL
426 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
427 ALTER TABLE t4 CHANGE c1 c1 DOUBLE NULL;
428 SHOW TABLES;
429 Tables_in_test
430 t4
431 SHOW CREATE TABLE t4;
432 Table Create Table
433 t4 CREATE TABLE `t4` (
434 `c1` double DEFAULT NULL
435 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
436 DROP TABLE t4;
437 SHOW TABLES;
438 Tables_in_test
439 CREATE TABLE t4(c1 FLOAT ZEROFILL NULL);
440 Warnings:
441 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
442 SHOW TABLES;
443 Tables_in_test
444 t4
445 SHOW CREATE TABLE t4;
446 Table Create Table
447 t4 CREATE TABLE `t4` (
448 `c1` float unsigned zerofill DEFAULT NULL
449 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
450 ALTER TABLE t4 CHANGE c1 c1 FLOAT NULL;
451 SHOW TABLES;
452 Tables_in_test
453 t4
454 SHOW CREATE TABLE t4;
455 Table Create Table
456 t4 CREATE TABLE `t4` (
457 `c1` float DEFAULT NULL
458 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
459 DROP TABLE t4;
460 SHOW TABLES;
461 Tables_in_test
462 CREATE TABLE t4(c1 DECIMAL ZEROFILL NULL);
463 Warnings:
464 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
465 SHOW TABLES;
466 Tables_in_test
467 t4
468 SHOW CREATE TABLE t4;
469 Table Create Table
470 t4 CREATE TABLE `t4` (
471 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
472 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
473 ALTER TABLE t4 CHANGE c1 c1 DECIMAL NULL;
474 SHOW TABLES;
475 Tables_in_test
476 t4
477 SHOW CREATE TABLE t4;
478 Table Create Table
479 t4 CREATE TABLE `t4` (
480 `c1` decimal(10,0) DEFAULT NULL
481 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
482 DROP TABLE t4;
483 SHOW TABLES;
484 Tables_in_test
485 CREATE TABLE t4(c1 NUMERIC ZEROFILL NULL);
486 Warnings:
487 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
488 SHOW TABLES;
489 Tables_in_test
490 t4
491 SHOW CREATE TABLE t4;
492 Table Create Table
493 t4 CREATE TABLE `t4` (
494 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
495 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
496 ALTER TABLE t4 CHANGE c1 c1 NUMERIC NULL;
497 SHOW TABLES;
498 Tables_in_test
499 t4
500 SHOW CREATE TABLE t4;
501 Table Create Table
502 t4 CREATE TABLE `t4` (
503 `c1` decimal(10,0) DEFAULT NULL
504 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
505 DROP TABLE t4;
506 SHOW TABLES;
507 Tables_in_test
508 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NULL);
509 Warnings:
510 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
511 SHOW TABLES;
512 Tables_in_test
513 t4
514 SHOW CREATE TABLE t4;
515 Table Create Table
516 t4 CREATE TABLE `t4` (
517 `c1` tinyint(3) unsigned zerofill DEFAULT NULL
518 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
519 ALTER TABLE t4 MODIFY c1 TINYINT UNSIGNED NULL;
520 SHOW TABLES;
521 Tables_in_test
522 t4
523 SHOW CREATE TABLE t4;
524 Table Create Table
525 t4 CREATE TABLE `t4` (
526 `c1` tinyint unsigned DEFAULT NULL
527 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
528 DROP TABLE t4;
529 SHOW TABLES;
530 Tables_in_test
531 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NULL);
532 Warnings:
533 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
534 SHOW TABLES;
535 Tables_in_test
536 t4
537 SHOW CREATE TABLE t4;
538 Table Create Table
539 t4 CREATE TABLE `t4` (
540 `c1` smallint(5) unsigned zerofill DEFAULT NULL
541 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
542 ALTER TABLE t4 MODIFY c1 SMALLINT UNSIGNED NULL;
543 SHOW TABLES;
544 Tables_in_test
545 t4
546 SHOW CREATE TABLE t4;
547 Table Create Table
548 t4 CREATE TABLE `t4` (
549 `c1` smallint unsigned DEFAULT NULL
550 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
551 DROP TABLE t4;
552 SHOW TABLES;
553 Tables_in_test
554 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NULL);
555 Warnings:
556 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
557 SHOW TABLES;
558 Tables_in_test
559 t4
560 SHOW CREATE TABLE t4;
561 Table Create Table
562 t4 CREATE TABLE `t4` (
563 `c1` mediumint(8) unsigned zerofill DEFAULT NULL
564 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
565 ALTER TABLE t4 MODIFY c1 MEDIUMINT UNSIGNED NULL;
566 SHOW TABLES;
567 Tables_in_test
568 t4
569 SHOW CREATE TABLE t4;
570 Table Create Table
571 t4 CREATE TABLE `t4` (
572 `c1` mediumint unsigned DEFAULT NULL
573 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
574 DROP TABLE t4;
575 SHOW TABLES;
576 Tables_in_test
577 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NULL);
578 Warnings:
579 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
580 SHOW TABLES;
581 Tables_in_test
582 t4
583 SHOW CREATE TABLE t4;
584 Table Create Table
585 t4 CREATE TABLE `t4` (
586 `c1` int(10) unsigned zerofill DEFAULT NULL
587 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
588 ALTER TABLE t4 MODIFY c1 INT UNSIGNED NULL;
589 SHOW TABLES;
590 Tables_in_test
591 t4
592 SHOW CREATE TABLE t4;
593 Table Create Table
594 t4 CREATE TABLE `t4` (
595 `c1` int unsigned DEFAULT NULL
596 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
597 DROP TABLE t4;
598 SHOW TABLES;
599 Tables_in_test
600 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NULL);
601 Warnings:
602 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
603 SHOW TABLES;
604 Tables_in_test
605 t4
606 SHOW CREATE TABLE t4;
607 Table Create Table
608 t4 CREATE TABLE `t4` (
609 `c1` int(10) unsigned zerofill DEFAULT NULL
610 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
611 ALTER TABLE t4 MODIFY c1 INTEGER UNSIGNED NULL;
612 SHOW TABLES;
613 Tables_in_test
614 t4
615 SHOW CREATE TABLE t4;
616 Table Create Table
617 t4 CREATE TABLE `t4` (
618 `c1` int unsigned DEFAULT NULL
619 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
620 DROP TABLE t4;
621 SHOW TABLES;
622 Tables_in_test
623 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NULL);
624 Warnings:
625 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
626 SHOW TABLES;
627 Tables_in_test
628 t4
629 SHOW CREATE TABLE t4;
630 Table Create Table
631 t4 CREATE TABLE `t4` (
632 `c1` bigint(20) unsigned zerofill DEFAULT NULL
633 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
634 ALTER TABLE t4 MODIFY c1 BIGINT UNSIGNED NULL;
635 SHOW TABLES;
636 Tables_in_test
637 t4
638 SHOW CREATE TABLE t4;
639 Table Create Table
640 t4 CREATE TABLE `t4` (
641 `c1` bigint unsigned DEFAULT NULL
642 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
643 DROP TABLE t4;
644 SHOW TABLES;
645 Tables_in_test
646 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NULL);
647 Warnings:
648 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
649 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
650 SHOW TABLES;
651 Tables_in_test
652 t4
653 SHOW CREATE TABLE t4;
654 Table Create Table
655 t4 CREATE TABLE `t4` (
656 `c1` double unsigned zerofill DEFAULT NULL
657 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
658 ALTER TABLE t4 MODIFY c1 REAL UNSIGNED NULL;
659 Warnings:
660 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
661 SHOW TABLES;
662 Tables_in_test
663 t4
664 SHOW CREATE TABLE t4;
665 Table Create Table
666 t4 CREATE TABLE `t4` (
667 `c1` double unsigned DEFAULT NULL
668 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
669 DROP TABLE t4;
670 SHOW TABLES;
671 Tables_in_test
672 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NULL);
673 Warnings:
674 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
675 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
676 SHOW TABLES;
677 Tables_in_test
678 t4
679 SHOW CREATE TABLE t4;
680 Table Create Table
681 t4 CREATE TABLE `t4` (
682 `c1` double unsigned zerofill DEFAULT NULL
683 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
684 ALTER TABLE t4 MODIFY c1 DOUBLE UNSIGNED NULL;
685 Warnings:
686 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
687 SHOW TABLES;
688 Tables_in_test
689 t4
690 SHOW CREATE TABLE t4;
691 Table Create Table
692 t4 CREATE TABLE `t4` (
693 `c1` double unsigned DEFAULT NULL
694 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
695 DROP TABLE t4;
696 SHOW TABLES;
697 Tables_in_test
698 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NULL);
699 Warnings:
700 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
701 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
702 SHOW TABLES;
703 Tables_in_test
704 t4
705 SHOW CREATE TABLE t4;
706 Table Create Table
707 t4 CREATE TABLE `t4` (
708 `c1` float unsigned zerofill DEFAULT NULL
709 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
710 ALTER TABLE t4 MODIFY c1 FLOAT UNSIGNED NULL;
711 Warnings:
712 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
713 SHOW TABLES;
714 Tables_in_test
715 t4
716 SHOW CREATE TABLE t4;
717 Table Create Table
718 t4 CREATE TABLE `t4` (
719 `c1` float unsigned DEFAULT NULL
720 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
721 DROP TABLE t4;
722 SHOW TABLES;
723 Tables_in_test
724 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NULL);
725 Warnings:
726 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
727 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
728 SHOW TABLES;
729 Tables_in_test
730 t4
731 SHOW CREATE TABLE t4;
732 Table Create Table
733 t4 CREATE TABLE `t4` (
734 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
735 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
736 ALTER TABLE t4 MODIFY c1 DECIMAL UNSIGNED NULL;
737 Warnings:
738 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
739 SHOW TABLES;
740 Tables_in_test
741 t4
742 SHOW CREATE TABLE t4;
743 Table Create Table
744 t4 CREATE TABLE `t4` (
745 `c1` decimal(10,0) unsigned DEFAULT NULL
746 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
747 DROP TABLE t4;
748 SHOW TABLES;
749 Tables_in_test
750 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NULL);
751 Warnings:
752 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
753 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
754 SHOW TABLES;
755 Tables_in_test
756 t4
757 SHOW CREATE TABLE t4;
758 Table Create Table
759 t4 CREATE TABLE `t4` (
760 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
761 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
762 ALTER TABLE t4 MODIFY c1 NUMERIC UNSIGNED NULL;
763 Warnings:
764 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
765 SHOW TABLES;
766 Tables_in_test
767 t4
768 SHOW CREATE TABLE t4;
769 Table Create Table
770 t4 CREATE TABLE `t4` (
771 `c1` decimal(10,0) unsigned DEFAULT NULL
772 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
773 DROP TABLE t4;
774 SHOW TABLES;
775 Tables_in_test
776 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NULL);
777 Warnings:
778 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
779 SHOW TABLES;
780 Tables_in_test
781 t4
782 SHOW CREATE TABLE t4;
783 Table Create Table
784 t4 CREATE TABLE `t4` (
785 `c1` tinyint(3) unsigned zerofill DEFAULT NULL
786 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
787 ALTER TABLE t4 CHANGE c1 c1 TINYINT UNSIGNED NULL;
788 SHOW TABLES;
789 Tables_in_test
790 t4
791 SHOW CREATE TABLE t4;
792 Table Create Table
793 t4 CREATE TABLE `t4` (
794 `c1` tinyint unsigned DEFAULT NULL
795 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
796 DROP TABLE t4;
797 SHOW TABLES;
798 Tables_in_test
799 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NULL);
800 Warnings:
801 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
802 SHOW TABLES;
803 Tables_in_test
804 t4
805 SHOW CREATE TABLE t4;
806 Table Create Table
807 t4 CREATE TABLE `t4` (
808 `c1` smallint(5) unsigned zerofill DEFAULT NULL
809 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
810 ALTER TABLE t4 CHANGE c1 c1 SMALLINT UNSIGNED NULL;
811 SHOW TABLES;
812 Tables_in_test
813 t4
814 SHOW CREATE TABLE t4;
815 Table Create Table
816 t4 CREATE TABLE `t4` (
817 `c1` smallint unsigned DEFAULT NULL
818 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
819 DROP TABLE t4;
820 SHOW TABLES;
821 Tables_in_test
822 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NULL);
823 Warnings:
824 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
825 SHOW TABLES;
826 Tables_in_test
827 t4
828 SHOW CREATE TABLE t4;
829 Table Create Table
830 t4 CREATE TABLE `t4` (
831 `c1` mediumint(8) unsigned zerofill DEFAULT NULL
832 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
833 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT UNSIGNED NULL;
834 SHOW TABLES;
835 Tables_in_test
836 t4
837 SHOW CREATE TABLE t4;
838 Table Create Table
839 t4 CREATE TABLE `t4` (
840 `c1` mediumint unsigned DEFAULT NULL
841 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
842 DROP TABLE t4;
843 SHOW TABLES;
844 Tables_in_test
845 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NULL);
846 Warnings:
847 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
848 SHOW TABLES;
849 Tables_in_test
850 t4
851 SHOW CREATE TABLE t4;
852 Table Create Table
853 t4 CREATE TABLE `t4` (
854 `c1` int(10) unsigned zerofill DEFAULT NULL
855 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
856 ALTER TABLE t4 CHANGE c1 c1 INT UNSIGNED NULL;
857 SHOW TABLES;
858 Tables_in_test
859 t4
860 SHOW CREATE TABLE t4;
861 Table Create Table
862 t4 CREATE TABLE `t4` (
863 `c1` int unsigned DEFAULT NULL
864 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
865 DROP TABLE t4;
866 SHOW TABLES;
867 Tables_in_test
868 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NULL);
869 Warnings:
870 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
871 SHOW TABLES;
872 Tables_in_test
873 t4
874 SHOW CREATE TABLE t4;
875 Table Create Table
876 t4 CREATE TABLE `t4` (
877 `c1` int(10) unsigned zerofill DEFAULT NULL
878 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
879 ALTER TABLE t4 CHANGE c1 c1 INTEGER UNSIGNED NULL;
880 SHOW TABLES;
881 Tables_in_test
882 t4
883 SHOW CREATE TABLE t4;
884 Table Create Table
885 t4 CREATE TABLE `t4` (
886 `c1` int unsigned DEFAULT NULL
887 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
888 DROP TABLE t4;
889 SHOW TABLES;
890 Tables_in_test
891 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NULL);
892 Warnings:
893 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
894 SHOW TABLES;
895 Tables_in_test
896 t4
897 SHOW CREATE TABLE t4;
898 Table Create Table
899 t4 CREATE TABLE `t4` (
900 `c1` bigint(20) unsigned zerofill DEFAULT NULL
901 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
902 ALTER TABLE t4 CHANGE c1 c1 BIGINT UNSIGNED NULL;
903 SHOW TABLES;
904 Tables_in_test
905 t4
906 SHOW CREATE TABLE t4;
907 Table Create Table
908 t4 CREATE TABLE `t4` (
909 `c1` bigint unsigned DEFAULT NULL
910 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
911 DROP TABLE t4;
912 SHOW TABLES;
913 Tables_in_test
914 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NULL);
915 Warnings:
916 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
917 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
918 SHOW TABLES;
919 Tables_in_test
920 t4
921 SHOW CREATE TABLE t4;
922 Table Create Table
923 t4 CREATE TABLE `t4` (
924 `c1` double unsigned zerofill DEFAULT NULL
925 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
926 ALTER TABLE t4 CHANGE c1 c1 REAL UNSIGNED NULL;
927 Warnings:
928 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
929 SHOW TABLES;
930 Tables_in_test
931 t4
932 SHOW CREATE TABLE t4;
933 Table Create Table
934 t4 CREATE TABLE `t4` (
935 `c1` double unsigned DEFAULT NULL
936 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
937 DROP TABLE t4;
938 SHOW TABLES;
939 Tables_in_test
940 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NULL);
941 Warnings:
942 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
943 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
944 SHOW TABLES;
945 Tables_in_test
946 t4
947 SHOW CREATE TABLE t4;
948 Table Create Table
949 t4 CREATE TABLE `t4` (
950 `c1` double unsigned zerofill DEFAULT NULL
951 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
952 ALTER TABLE t4 CHANGE c1 c1 DOUBLE UNSIGNED NULL;
953 Warnings:
954 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
955 SHOW TABLES;
956 Tables_in_test
957 t4
958 SHOW CREATE TABLE t4;
959 Table Create Table
960 t4 CREATE TABLE `t4` (
961 `c1` double unsigned DEFAULT NULL
962 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
963 DROP TABLE t4;
964 SHOW TABLES;
965 Tables_in_test
966 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NULL);
967 Warnings:
968 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
969 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
970 SHOW TABLES;
971 Tables_in_test
972 t4
973 SHOW CREATE TABLE t4;
974 Table Create Table
975 t4 CREATE TABLE `t4` (
976 `c1` float unsigned zerofill DEFAULT NULL
977 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
978 ALTER TABLE t4 CHANGE c1 c1 FLOAT UNSIGNED NULL;
979 Warnings:
980 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
981 SHOW TABLES;
982 Tables_in_test
983 t4
984 SHOW CREATE TABLE t4;
985 Table Create Table
986 t4 CREATE TABLE `t4` (
987 `c1` float unsigned DEFAULT NULL
988 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
989 DROP TABLE t4;
990 SHOW TABLES;
991 Tables_in_test
992 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NULL);
993 Warnings:
994 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
995 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
996 SHOW TABLES;
997 Tables_in_test
998 t4
999 SHOW CREATE TABLE t4;
1000 Table Create Table
1001 t4 CREATE TABLE `t4` (
1002 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
1003 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1004 ALTER TABLE t4 CHANGE c1 c1 DECIMAL UNSIGNED NULL;
1005 Warnings:
1006 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1007 SHOW TABLES;
1008 Tables_in_test
1009 t4
1010 SHOW CREATE TABLE t4;
1011 Table Create Table
1012 t4 CREATE TABLE `t4` (
1013 `c1` decimal(10,0) unsigned DEFAULT NULL
1014 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1015 DROP TABLE t4;
1016 SHOW TABLES;
1017 Tables_in_test
1018 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NULL);
1019 Warnings:
1020 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1021 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1022 SHOW TABLES;
1023 Tables_in_test
1024 t4
1025 SHOW CREATE TABLE t4;
1026 Table Create Table
1027 t4 CREATE TABLE `t4` (
1028 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
1029 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1030 ALTER TABLE t4 CHANGE c1 c1 NUMERIC UNSIGNED NULL;
1031 Warnings:
1032 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1033 SHOW TABLES;
1034 Tables_in_test
1035 t4
1036 SHOW CREATE TABLE t4;
1037 Table Create Table
1038 t4 CREATE TABLE `t4` (
1039 `c1` decimal(10,0) unsigned DEFAULT NULL
1040 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1041 DROP TABLE t4;
1042 SHOW TABLES;
1043 Tables_in_test
1044 CREATE TABLE t4(c1 TINYINT ZEROFILL NOT NULL);
1045 Warnings:
1046 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1047 SHOW TABLES;
1048 Tables_in_test
1049 t4
1050 SHOW CREATE TABLE t4;
1051 Table Create Table
1052 t4 CREATE TABLE `t4` (
1053 `c1` tinyint(3) unsigned zerofill NOT NULL
1054 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1055 ALTER TABLE t4 MODIFY c1 TINYINT NOT NULL;
1056 SHOW TABLES;
1057 Tables_in_test
1058 t4
1059 SHOW CREATE TABLE t4;
1060 Table Create Table
1061 t4 CREATE TABLE `t4` (
1062 `c1` tinyint NOT NULL
1063 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1064 DROP TABLE t4;
1065 SHOW TABLES;
1066 Tables_in_test
1067 CREATE TABLE t4(c1 SMALLINT ZEROFILL NOT NULL);
1068 Warnings:
1069 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1070 SHOW TABLES;
1071 Tables_in_test
1072 t4
1073 SHOW CREATE TABLE t4;
1074 Table Create Table
1075 t4 CREATE TABLE `t4` (
1076 `c1` smallint(5) unsigned zerofill NOT NULL
1077 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1078 ALTER TABLE t4 MODIFY c1 SMALLINT NOT NULL;
1079 SHOW TABLES;
1080 Tables_in_test
1081 t4
1082 SHOW CREATE TABLE t4;
1083 Table Create Table
1084 t4 CREATE TABLE `t4` (
1085 `c1` smallint NOT NULL
1086 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1087 DROP TABLE t4;
1088 SHOW TABLES;
1089 Tables_in_test
1090 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NOT NULL);
1091 Warnings:
1092 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1093 SHOW TABLES;
1094 Tables_in_test
1095 t4
1096 SHOW CREATE TABLE t4;
1097 Table Create Table
1098 t4 CREATE TABLE `t4` (
1099 `c1` mediumint(8) unsigned zerofill NOT NULL
1100 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1101 ALTER TABLE t4 MODIFY c1 MEDIUMINT NOT NULL;
1102 SHOW TABLES;
1103 Tables_in_test
1104 t4
1105 SHOW CREATE TABLE t4;
1106 Table Create Table
1107 t4 CREATE TABLE `t4` (
1108 `c1` mediumint NOT NULL
1109 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1110 DROP TABLE t4;
1111 SHOW TABLES;
1112 Tables_in_test
1113 CREATE TABLE t4(c1 INT ZEROFILL NOT NULL);
1114 Warnings:
1115 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1116 SHOW TABLES;
1117 Tables_in_test
1118 t4
1119 SHOW CREATE TABLE t4;
1120 Table Create Table
1121 t4 CREATE TABLE `t4` (
1122 `c1` int(10) unsigned zerofill NOT NULL
1123 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1124 ALTER TABLE t4 MODIFY c1 INT NOT NULL;
1125 SHOW TABLES;
1126 Tables_in_test
1127 t4
1128 SHOW CREATE TABLE t4;
1129 Table Create Table
1130 t4 CREATE TABLE `t4` (
1131 `c1` int NOT NULL
1132 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1133 DROP TABLE t4;
1134 SHOW TABLES;
1135 Tables_in_test
1136 CREATE TABLE t4(c1 INTEGER ZEROFILL NOT NULL);
1137 Warnings:
1138 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1139 SHOW TABLES;
1140 Tables_in_test
1141 t4
1142 SHOW CREATE TABLE t4;
1143 Table Create Table
1144 t4 CREATE TABLE `t4` (
1145 `c1` int(10) unsigned zerofill NOT NULL
1146 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1147 ALTER TABLE t4 MODIFY c1 INTEGER NOT NULL;
1148 SHOW TABLES;
1149 Tables_in_test
1150 t4
1151 SHOW CREATE TABLE t4;
1152 Table Create Table
1153 t4 CREATE TABLE `t4` (
1154 `c1` int NOT NULL
1155 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1156 DROP TABLE t4;
1157 SHOW TABLES;
1158 Tables_in_test
1159 CREATE TABLE t4(c1 BIGINT ZEROFILL NOT NULL);
1160 Warnings:
1161 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1162 SHOW TABLES;
1163 Tables_in_test
1164 t4
1165 SHOW CREATE TABLE t4;
1166 Table Create Table
1167 t4 CREATE TABLE `t4` (
1168 `c1` bigint(20) unsigned zerofill NOT NULL
1169 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1170 ALTER TABLE t4 MODIFY c1 BIGINT NOT NULL;
1171 SHOW TABLES;
1172 Tables_in_test
1173 t4
1174 SHOW CREATE TABLE t4;
1175 Table Create Table
1176 t4 CREATE TABLE `t4` (
1177 `c1` bigint NOT NULL
1178 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1179 DROP TABLE t4;
1180 SHOW TABLES;
1181 Tables_in_test
1182 CREATE TABLE t4(c1 REAL ZEROFILL NOT NULL);
1183 Warnings:
1184 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1185 SHOW TABLES;
1186 Tables_in_test
1187 t4
1188 SHOW CREATE TABLE t4;
1189 Table Create Table
1190 t4 CREATE TABLE `t4` (
1191 `c1` double unsigned zerofill NOT NULL
1192 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1193 ALTER TABLE t4 MODIFY c1 REAL NOT NULL;
1194 SHOW TABLES;
1195 Tables_in_test
1196 t4
1197 SHOW CREATE TABLE t4;
1198 Table Create Table
1199 t4 CREATE TABLE `t4` (
1200 `c1` double NOT NULL
1201 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1202 DROP TABLE t4;
1203 SHOW TABLES;
1204 Tables_in_test
1205 CREATE TABLE t4(c1 DOUBLE ZEROFILL NOT NULL);
1206 Warnings:
1207 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1208 SHOW TABLES;
1209 Tables_in_test
1210 t4
1211 SHOW CREATE TABLE t4;
1212 Table Create Table
1213 t4 CREATE TABLE `t4` (
1214 `c1` double unsigned zerofill NOT NULL
1215 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1216 ALTER TABLE t4 MODIFY c1 DOUBLE NOT NULL;
1217 SHOW TABLES;
1218 Tables_in_test
1219 t4
1220 SHOW CREATE TABLE t4;
1221 Table Create Table
1222 t4 CREATE TABLE `t4` (
1223 `c1` double NOT NULL
1224 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1225 DROP TABLE t4;
1226 SHOW TABLES;
1227 Tables_in_test
1228 CREATE TABLE t4(c1 FLOAT ZEROFILL NOT NULL);
1229 Warnings:
1230 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1231 SHOW TABLES;
1232 Tables_in_test
1233 t4
1234 SHOW CREATE TABLE t4;
1235 Table Create Table
1236 t4 CREATE TABLE `t4` (
1237 `c1` float unsigned zerofill NOT NULL
1238 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1239 ALTER TABLE t4 MODIFY c1 FLOAT NOT NULL;
1240 SHOW TABLES;
1241 Tables_in_test
1242 t4
1243 SHOW CREATE TABLE t4;
1244 Table Create Table
1245 t4 CREATE TABLE `t4` (
1246 `c1` float NOT NULL
1247 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1248 DROP TABLE t4;
1249 SHOW TABLES;
1250 Tables_in_test
1251 CREATE TABLE t4(c1 DECIMAL ZEROFILL NOT NULL);
1252 Warnings:
1253 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1254 SHOW TABLES;
1255 Tables_in_test
1256 t4
1257 SHOW CREATE TABLE t4;
1258 Table Create Table
1259 t4 CREATE TABLE `t4` (
1260 `c1` decimal(10,0) unsigned zerofill NOT NULL
1261 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1262 ALTER TABLE t4 MODIFY c1 DECIMAL NOT NULL;
1263 SHOW TABLES;
1264 Tables_in_test
1265 t4
1266 SHOW CREATE TABLE t4;
1267 Table Create Table
1268 t4 CREATE TABLE `t4` (
1269 `c1` decimal(10,0) NOT NULL
1270 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1271 DROP TABLE t4;
1272 SHOW TABLES;
1273 Tables_in_test
1274 CREATE TABLE t4(c1 NUMERIC ZEROFILL NOT NULL);
1275 Warnings:
1276 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1277 SHOW TABLES;
1278 Tables_in_test
1279 t4
1280 SHOW CREATE TABLE t4;
1281 Table Create Table
1282 t4 CREATE TABLE `t4` (
1283 `c1` decimal(10,0) unsigned zerofill NOT NULL
1284 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1285 ALTER TABLE t4 MODIFY c1 NUMERIC NOT NULL;
1286 SHOW TABLES;
1287 Tables_in_test
1288 t4
1289 SHOW CREATE TABLE t4;
1290 Table Create Table
1291 t4 CREATE TABLE `t4` (
1292 `c1` decimal(10,0) NOT NULL
1293 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1294 DROP TABLE t4;
1295 SHOW TABLES;
1296 Tables_in_test
1297 CREATE TABLE t4(c1 TINYINT ZEROFILL NOT NULL);
1298 Warnings:
1299 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1300 SHOW TABLES;
1301 Tables_in_test
1302 t4
1303 SHOW CREATE TABLE t4;
1304 Table Create Table
1305 t4 CREATE TABLE `t4` (
1306 `c1` tinyint(3) unsigned zerofill NOT NULL
1307 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1308 ALTER TABLE t4 CHANGE c1 c1 TINYINT NOT NULL;
1309 SHOW TABLES;
1310 Tables_in_test
1311 t4
1312 SHOW CREATE TABLE t4;
1313 Table Create Table
1314 t4 CREATE TABLE `t4` (
1315 `c1` tinyint NOT NULL
1316 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1317 DROP TABLE t4;
1318 SHOW TABLES;
1319 Tables_in_test
1320 CREATE TABLE t4(c1 SMALLINT ZEROFILL NOT NULL);
1321 Warnings:
1322 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1323 SHOW TABLES;
1324 Tables_in_test
1325 t4
1326 SHOW CREATE TABLE t4;
1327 Table Create Table
1328 t4 CREATE TABLE `t4` (
1329 `c1` smallint(5) unsigned zerofill NOT NULL
1330 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1331 ALTER TABLE t4 CHANGE c1 c1 SMALLINT NOT NULL;
1332 SHOW TABLES;
1333 Tables_in_test
1334 t4
1335 SHOW CREATE TABLE t4;
1336 Table Create Table
1337 t4 CREATE TABLE `t4` (
1338 `c1` smallint NOT NULL
1339 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1340 DROP TABLE t4;
1341 SHOW TABLES;
1342 Tables_in_test
1343 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NOT NULL);
1344 Warnings:
1345 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1346 SHOW TABLES;
1347 Tables_in_test
1348 t4
1349 SHOW CREATE TABLE t4;
1350 Table Create Table
1351 t4 CREATE TABLE `t4` (
1352 `c1` mediumint(8) unsigned zerofill NOT NULL
1353 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1354 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT NOT NULL;
1355 SHOW TABLES;
1356 Tables_in_test
1357 t4
1358 SHOW CREATE TABLE t4;
1359 Table Create Table
1360 t4 CREATE TABLE `t4` (
1361 `c1` mediumint NOT NULL
1362 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1363 DROP TABLE t4;
1364 SHOW TABLES;
1365 Tables_in_test
1366 CREATE TABLE t4(c1 INT ZEROFILL NOT NULL);
1367 Warnings:
1368 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1369 SHOW TABLES;
1370 Tables_in_test
1371 t4
1372 SHOW CREATE TABLE t4;
1373 Table Create Table
1374 t4 CREATE TABLE `t4` (
1375 `c1` int(10) unsigned zerofill NOT NULL
1376 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1377 ALTER TABLE t4 CHANGE c1 c1 INT NOT NULL;
1378 SHOW TABLES;
1379 Tables_in_test
1380 t4
1381 SHOW CREATE TABLE t4;
1382 Table Create Table
1383 t4 CREATE TABLE `t4` (
1384 `c1` int NOT NULL
1385 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1386 DROP TABLE t4;
1387 SHOW TABLES;
1388 Tables_in_test
1389 CREATE TABLE t4(c1 INTEGER ZEROFILL NOT NULL);
1390 Warnings:
1391 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1392 SHOW TABLES;
1393 Tables_in_test
1394 t4
1395 SHOW CREATE TABLE t4;
1396 Table Create Table
1397 t4 CREATE TABLE `t4` (
1398 `c1` int(10) unsigned zerofill NOT NULL
1399 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1400 ALTER TABLE t4 CHANGE c1 c1 INTEGER NOT NULL;
1401 SHOW TABLES;
1402 Tables_in_test
1403 t4
1404 SHOW CREATE TABLE t4;
1405 Table Create Table
1406 t4 CREATE TABLE `t4` (
1407 `c1` int NOT NULL
1408 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1409 DROP TABLE t4;
1410 SHOW TABLES;
1411 Tables_in_test
1412 CREATE TABLE t4(c1 BIGINT ZEROFILL NOT NULL);
1413 Warnings:
1414 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1415 SHOW TABLES;
1416 Tables_in_test
1417 t4
1418 SHOW CREATE TABLE t4;
1419 Table Create Table
1420 t4 CREATE TABLE `t4` (
1421 `c1` bigint(20) unsigned zerofill NOT NULL
1422 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1423 ALTER TABLE t4 CHANGE c1 c1 BIGINT NOT NULL;
1424 SHOW TABLES;
1425 Tables_in_test
1426 t4
1427 SHOW CREATE TABLE t4;
1428 Table Create Table
1429 t4 CREATE TABLE `t4` (
1430 `c1` bigint NOT NULL
1431 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1432 DROP TABLE t4;
1433 SHOW TABLES;
1434 Tables_in_test
1435 CREATE TABLE t4(c1 REAL ZEROFILL NOT NULL);
1436 Warnings:
1437 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1438 SHOW TABLES;
1439 Tables_in_test
1440 t4
1441 SHOW CREATE TABLE t4;
1442 Table Create Table
1443 t4 CREATE TABLE `t4` (
1444 `c1` double unsigned zerofill NOT NULL
1445 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1446 ALTER TABLE t4 CHANGE c1 c1 REAL NOT NULL;
1447 SHOW TABLES;
1448 Tables_in_test
1449 t4
1450 SHOW CREATE TABLE t4;
1451 Table Create Table
1452 t4 CREATE TABLE `t4` (
1453 `c1` double NOT NULL
1454 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1455 DROP TABLE t4;
1456 SHOW TABLES;
1457 Tables_in_test
1458 CREATE TABLE t4(c1 DOUBLE ZEROFILL NOT NULL);
1459 Warnings:
1460 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1461 SHOW TABLES;
1462 Tables_in_test
1463 t4
1464 SHOW CREATE TABLE t4;
1465 Table Create Table
1466 t4 CREATE TABLE `t4` (
1467 `c1` double unsigned zerofill NOT NULL
1468 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1469 ALTER TABLE t4 CHANGE c1 c1 DOUBLE NOT NULL;
1470 SHOW TABLES;
1471 Tables_in_test
1472 t4
1473 SHOW CREATE TABLE t4;
1474 Table Create Table
1475 t4 CREATE TABLE `t4` (
1476 `c1` double NOT NULL
1477 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1478 DROP TABLE t4;
1479 SHOW TABLES;
1480 Tables_in_test
1481 CREATE TABLE t4(c1 FLOAT ZEROFILL NOT NULL);
1482 Warnings:
1483 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1484 SHOW TABLES;
1485 Tables_in_test
1486 t4
1487 SHOW CREATE TABLE t4;
1488 Table Create Table
1489 t4 CREATE TABLE `t4` (
1490 `c1` float unsigned zerofill NOT NULL
1491 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1492 ALTER TABLE t4 CHANGE c1 c1 FLOAT NOT NULL;
1493 SHOW TABLES;
1494 Tables_in_test
1495 t4
1496 SHOW CREATE TABLE t4;
1497 Table Create Table
1498 t4 CREATE TABLE `t4` (
1499 `c1` float NOT NULL
1500 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1501 DROP TABLE t4;
1502 SHOW TABLES;
1503 Tables_in_test
1504 CREATE TABLE t4(c1 DECIMAL ZEROFILL NOT NULL);
1505 Warnings:
1506 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1507 SHOW TABLES;
1508 Tables_in_test
1509 t4
1510 SHOW CREATE TABLE t4;
1511 Table Create Table
1512 t4 CREATE TABLE `t4` (
1513 `c1` decimal(10,0) unsigned zerofill NOT NULL
1514 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1515 ALTER TABLE t4 CHANGE c1 c1 DECIMAL NOT NULL;
1516 SHOW TABLES;
1517 Tables_in_test
1518 t4
1519 SHOW CREATE TABLE t4;
1520 Table Create Table
1521 t4 CREATE TABLE `t4` (
1522 `c1` decimal(10,0) NOT NULL
1523 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1524 DROP TABLE t4;
1525 SHOW TABLES;
1526 Tables_in_test
1527 CREATE TABLE t4(c1 NUMERIC ZEROFILL NOT NULL);
1528 Warnings:
1529 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1530 SHOW TABLES;
1531 Tables_in_test
1532 t4
1533 SHOW CREATE TABLE t4;
1534 Table Create Table
1535 t4 CREATE TABLE `t4` (
1536 `c1` decimal(10,0) unsigned zerofill NOT NULL
1537 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1538 ALTER TABLE t4 CHANGE c1 c1 NUMERIC NOT NULL;
1539 SHOW TABLES;
1540 Tables_in_test
1541 t4
1542 SHOW CREATE TABLE t4;
1543 Table Create Table
1544 t4 CREATE TABLE `t4` (
1545 `c1` decimal(10,0) NOT NULL
1546 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1547 DROP TABLE t4;
1548 SHOW TABLES;
1549 Tables_in_test
1550 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NOT NULL);
1551 Warnings:
1552 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1553 SHOW TABLES;
1554 Tables_in_test
1555 t4
1556 SHOW CREATE TABLE t4;
1557 Table Create Table
1558 t4 CREATE TABLE `t4` (
1559 `c1` tinyint(3) unsigned zerofill NOT NULL
1560 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1561 ALTER TABLE t4 MODIFY c1 TINYINT UNSIGNED NOT NULL;
1562 SHOW TABLES;
1563 Tables_in_test
1564 t4
1565 SHOW CREATE TABLE t4;
1566 Table Create Table
1567 t4 CREATE TABLE `t4` (
1568 `c1` tinyint unsigned NOT NULL
1569 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1570 DROP TABLE t4;
1571 SHOW TABLES;
1572 Tables_in_test
1573 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NOT NULL);
1574 Warnings:
1575 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1576 SHOW TABLES;
1577 Tables_in_test
1578 t4
1579 SHOW CREATE TABLE t4;
1580 Table Create Table
1581 t4 CREATE TABLE `t4` (
1582 `c1` smallint(5) unsigned zerofill NOT NULL
1583 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1584 ALTER TABLE t4 MODIFY c1 SMALLINT UNSIGNED NOT NULL;
1585 SHOW TABLES;
1586 Tables_in_test
1587 t4
1588 SHOW CREATE TABLE t4;
1589 Table Create Table
1590 t4 CREATE TABLE `t4` (
1591 `c1` smallint unsigned NOT NULL
1592 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1593 DROP TABLE t4;
1594 SHOW TABLES;
1595 Tables_in_test
1596 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL);
1597 Warnings:
1598 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1599 SHOW TABLES;
1600 Tables_in_test
1601 t4
1602 SHOW CREATE TABLE t4;
1603 Table Create Table
1604 t4 CREATE TABLE `t4` (
1605 `c1` mediumint(8) unsigned zerofill NOT NULL
1606 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1607 ALTER TABLE t4 MODIFY c1 MEDIUMINT UNSIGNED NOT NULL;
1608 SHOW TABLES;
1609 Tables_in_test
1610 t4
1611 SHOW CREATE TABLE t4;
1612 Table Create Table
1613 t4 CREATE TABLE `t4` (
1614 `c1` mediumint unsigned NOT NULL
1615 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1616 DROP TABLE t4;
1617 SHOW TABLES;
1618 Tables_in_test
1619 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NOT NULL);
1620 Warnings:
1621 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1622 SHOW TABLES;
1623 Tables_in_test
1624 t4
1625 SHOW CREATE TABLE t4;
1626 Table Create Table
1627 t4 CREATE TABLE `t4` (
1628 `c1` int(10) unsigned zerofill NOT NULL
1629 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1630 ALTER TABLE t4 MODIFY c1 INT UNSIGNED NOT NULL;
1631 SHOW TABLES;
1632 Tables_in_test
1633 t4
1634 SHOW CREATE TABLE t4;
1635 Table Create Table
1636 t4 CREATE TABLE `t4` (
1637 `c1` int unsigned NOT NULL
1638 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1639 DROP TABLE t4;
1640 SHOW TABLES;
1641 Tables_in_test
1642 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NOT NULL);
1643 Warnings:
1644 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1645 SHOW TABLES;
1646 Tables_in_test
1647 t4
1648 SHOW CREATE TABLE t4;
1649 Table Create Table
1650 t4 CREATE TABLE `t4` (
1651 `c1` int(10) unsigned zerofill NOT NULL
1652 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1653 ALTER TABLE t4 MODIFY c1 INTEGER UNSIGNED NOT NULL;
1654 SHOW TABLES;
1655 Tables_in_test
1656 t4
1657 SHOW CREATE TABLE t4;
1658 Table Create Table
1659 t4 CREATE TABLE `t4` (
1660 `c1` int unsigned NOT NULL
1661 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1662 DROP TABLE t4;
1663 SHOW TABLES;
1664 Tables_in_test
1665 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NOT NULL);
1666 Warnings:
1667 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1668 SHOW TABLES;
1669 Tables_in_test
1670 t4
1671 SHOW CREATE TABLE t4;
1672 Table Create Table
1673 t4 CREATE TABLE `t4` (
1674 `c1` bigint(20) unsigned zerofill NOT NULL
1675 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1676 ALTER TABLE t4 MODIFY c1 BIGINT UNSIGNED NOT NULL;
1677 SHOW TABLES;
1678 Tables_in_test
1679 t4
1680 SHOW CREATE TABLE t4;
1681 Table Create Table
1682 t4 CREATE TABLE `t4` (
1683 `c1` bigint unsigned NOT NULL
1684 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1685 DROP TABLE t4;
1686 SHOW TABLES;
1687 Tables_in_test
1688 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NOT NULL);
1689 Warnings:
1690 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1691 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1692 SHOW TABLES;
1693 Tables_in_test
1694 t4
1695 SHOW CREATE TABLE t4;
1696 Table Create Table
1697 t4 CREATE TABLE `t4` (
1698 `c1` double unsigned zerofill NOT NULL
1699 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1700 ALTER TABLE t4 MODIFY c1 REAL UNSIGNED NOT NULL;
1701 Warnings:
1702 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1703 SHOW TABLES;
1704 Tables_in_test
1705 t4
1706 SHOW CREATE TABLE t4;
1707 Table Create Table
1708 t4 CREATE TABLE `t4` (
1709 `c1` double unsigned NOT NULL
1710 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1711 DROP TABLE t4;
1712 SHOW TABLES;
1713 Tables_in_test
1714 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NOT NULL);
1715 Warnings:
1716 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1717 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1718 SHOW TABLES;
1719 Tables_in_test
1720 t4
1721 SHOW CREATE TABLE t4;
1722 Table Create Table
1723 t4 CREATE TABLE `t4` (
1724 `c1` double unsigned zerofill NOT NULL
1725 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1726 ALTER TABLE t4 MODIFY c1 DOUBLE UNSIGNED NOT NULL;
1727 Warnings:
1728 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1729 SHOW TABLES;
1730 Tables_in_test
1731 t4
1732 SHOW CREATE TABLE t4;
1733 Table Create Table
1734 t4 CREATE TABLE `t4` (
1735 `c1` double unsigned NOT NULL
1736 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1737 DROP TABLE t4;
1738 SHOW TABLES;
1739 Tables_in_test
1740 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NOT NULL);
1741 Warnings:
1742 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1743 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1744 SHOW TABLES;
1745 Tables_in_test
1746 t4
1747 SHOW CREATE TABLE t4;
1748 Table Create Table
1749 t4 CREATE TABLE `t4` (
1750 `c1` float unsigned zerofill NOT NULL
1751 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1752 ALTER TABLE t4 MODIFY c1 FLOAT UNSIGNED NOT NULL;
1753 Warnings:
1754 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1755 SHOW TABLES;
1756 Tables_in_test
1757 t4
1758 SHOW CREATE TABLE t4;
1759 Table Create Table
1760 t4 CREATE TABLE `t4` (
1761 `c1` float unsigned NOT NULL
1762 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1763 DROP TABLE t4;
1764 SHOW TABLES;
1765 Tables_in_test
1766 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NOT NULL);
1767 Warnings:
1768 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1769 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1770 SHOW TABLES;
1771 Tables_in_test
1772 t4
1773 SHOW CREATE TABLE t4;
1774 Table Create Table
1775 t4 CREATE TABLE `t4` (
1776 `c1` decimal(10,0) unsigned zerofill NOT NULL
1777 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1778 ALTER TABLE t4 MODIFY c1 DECIMAL UNSIGNED NOT NULL;
1779 Warnings:
1780 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1781 SHOW TABLES;
1782 Tables_in_test
1783 t4
1784 SHOW CREATE TABLE t4;
1785 Table Create Table
1786 t4 CREATE TABLE `t4` (
1787 `c1` decimal(10,0) unsigned NOT NULL
1788 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1789 DROP TABLE t4;
1790 SHOW TABLES;
1791 Tables_in_test
1792 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NOT NULL);
1793 Warnings:
1794 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1795 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1796 SHOW TABLES;
1797 Tables_in_test
1798 t4
1799 SHOW CREATE TABLE t4;
1800 Table Create Table
1801 t4 CREATE TABLE `t4` (
1802 `c1` decimal(10,0) unsigned zerofill NOT NULL
1803 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1804 ALTER TABLE t4 MODIFY c1 NUMERIC UNSIGNED NOT NULL;
1805 Warnings:
1806 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1807 SHOW TABLES;
1808 Tables_in_test
1809 t4
1810 SHOW CREATE TABLE t4;
1811 Table Create Table
1812 t4 CREATE TABLE `t4` (
1813 `c1` decimal(10,0) unsigned NOT NULL
1814 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1815 DROP TABLE t4;
1816 SHOW TABLES;
1817 Tables_in_test
1818 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NOT NULL);
1819 Warnings:
1820 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1821 SHOW TABLES;
1822 Tables_in_test
1823 t4
1824 SHOW CREATE TABLE t4;
1825 Table Create Table
1826 t4 CREATE TABLE `t4` (
1827 `c1` tinyint(3) unsigned zerofill NOT NULL
1828 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1829 ALTER TABLE t4 CHANGE c1 c1 TINYINT UNSIGNED NOT NULL;
1830 SHOW TABLES;
1831 Tables_in_test
1832 t4
1833 SHOW CREATE TABLE t4;
1834 Table Create Table
1835 t4 CREATE TABLE `t4` (
1836 `c1` tinyint unsigned NOT NULL
1837 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1838 DROP TABLE t4;
1839 SHOW TABLES;
1840 Tables_in_test
1841 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NOT NULL);
1842 Warnings:
1843 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1844 SHOW TABLES;
1845 Tables_in_test
1846 t4
1847 SHOW CREATE TABLE t4;
1848 Table Create Table
1849 t4 CREATE TABLE `t4` (
1850 `c1` smallint(5) unsigned zerofill NOT NULL
1851 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1852 ALTER TABLE t4 CHANGE c1 c1 SMALLINT UNSIGNED NOT NULL;
1853 SHOW TABLES;
1854 Tables_in_test
1855 t4
1856 SHOW CREATE TABLE t4;
1857 Table Create Table
1858 t4 CREATE TABLE `t4` (
1859 `c1` smallint unsigned NOT NULL
1860 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1861 DROP TABLE t4;
1862 SHOW TABLES;
1863 Tables_in_test
1864 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL);
1865 Warnings:
1866 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1867 SHOW TABLES;
1868 Tables_in_test
1869 t4
1870 SHOW CREATE TABLE t4;
1871 Table Create Table
1872 t4 CREATE TABLE `t4` (
1873 `c1` mediumint(8) unsigned zerofill NOT NULL
1874 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1875 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT UNSIGNED NOT NULL;
1876 SHOW TABLES;
1877 Tables_in_test
1878 t4
1879 SHOW CREATE TABLE t4;
1880 Table Create Table
1881 t4 CREATE TABLE `t4` (
1882 `c1` mediumint unsigned NOT NULL
1883 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1884 DROP TABLE t4;
1885 SHOW TABLES;
1886 Tables_in_test
1887 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NOT NULL);
1888 Warnings:
1889 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1890 SHOW TABLES;
1891 Tables_in_test
1892 t4
1893 SHOW CREATE TABLE t4;
1894 Table Create Table
1895 t4 CREATE TABLE `t4` (
1896 `c1` int(10) unsigned zerofill NOT NULL
1897 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1898 ALTER TABLE t4 CHANGE c1 c1 INT UNSIGNED NOT NULL;
1899 SHOW TABLES;
1900 Tables_in_test
1901 t4
1902 SHOW CREATE TABLE t4;
1903 Table Create Table
1904 t4 CREATE TABLE `t4` (
1905 `c1` int unsigned NOT NULL
1906 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1907 DROP TABLE t4;
1908 SHOW TABLES;
1909 Tables_in_test
1910 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NOT NULL);
1911 Warnings:
1912 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1913 SHOW TABLES;
1914 Tables_in_test
1915 t4
1916 SHOW CREATE TABLE t4;
1917 Table Create Table
1918 t4 CREATE TABLE `t4` (
1919 `c1` int(10) unsigned zerofill NOT NULL
1920 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1921 ALTER TABLE t4 CHANGE c1 c1 INTEGER UNSIGNED NOT NULL;
1922 SHOW TABLES;
1923 Tables_in_test
1924 t4
1925 SHOW CREATE TABLE t4;
1926 Table Create Table
1927 t4 CREATE TABLE `t4` (
1928 `c1` int unsigned NOT NULL
1929 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1930 DROP TABLE t4;
1931 SHOW TABLES;
1932 Tables_in_test
1933 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NOT NULL);
1934 Warnings:
1935 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1936 SHOW TABLES;
1937 Tables_in_test
1938 t4
1939 SHOW CREATE TABLE t4;
1940 Table Create Table
1941 t4 CREATE TABLE `t4` (
1942 `c1` bigint(20) unsigned zerofill NOT NULL
1943 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1944 ALTER TABLE t4 CHANGE c1 c1 BIGINT UNSIGNED NOT NULL;
1945 SHOW TABLES;
1946 Tables_in_test
1947 t4
1948 SHOW CREATE TABLE t4;
1949 Table Create Table
1950 t4 CREATE TABLE `t4` (
1951 `c1` bigint unsigned NOT NULL
1952 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1953 DROP TABLE t4;
1954 SHOW TABLES;
1955 Tables_in_test
1956 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NOT NULL);
1957 Warnings:
1958 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1959 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1960 SHOW TABLES;
1961 Tables_in_test
1962 t4
1963 SHOW CREATE TABLE t4;
1964 Table Create Table
1965 t4 CREATE TABLE `t4` (
1966 `c1` double unsigned zerofill NOT NULL
1967 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1968 ALTER TABLE t4 CHANGE c1 c1 REAL UNSIGNED NOT NULL;
1969 Warnings:
1970 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1971 SHOW TABLES;
1972 Tables_in_test
1973 t4
1974 SHOW CREATE TABLE t4;
1975 Table Create Table
1976 t4 CREATE TABLE `t4` (
1977 `c1` double unsigned NOT NULL
1978 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1979 DROP TABLE t4;
1980 SHOW TABLES;
1981 Tables_in_test
1982 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NOT NULL);
1983 Warnings:
1984 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
1985 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1986 SHOW TABLES;
1987 Tables_in_test
1988 t4
1989 SHOW CREATE TABLE t4;
1990 Table Create Table
1991 t4 CREATE TABLE `t4` (
1992 `c1` double unsigned zerofill NOT NULL
1993 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1994 ALTER TABLE t4 CHANGE c1 c1 DOUBLE UNSIGNED NOT NULL;
1995 Warnings:
1996 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1997 SHOW TABLES;
1998 Tables_in_test
1999 t4
2000 SHOW CREATE TABLE t4;
2001 Table Create Table
2002 t4 CREATE TABLE `t4` (
2003 `c1` double unsigned NOT NULL
2004 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2005 DROP TABLE t4;
2006 SHOW TABLES;
2007 Tables_in_test
2008 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NOT NULL);
2009 Warnings:
2010 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
2011 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
2012 SHOW TABLES;
2013 Tables_in_test
2014 t4
2015 SHOW CREATE TABLE t4;
2016 Table Create Table
2017 t4 CREATE TABLE `t4` (
2018 `c1` float unsigned zerofill NOT NULL
2019 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2020 ALTER TABLE t4 CHANGE c1 c1 FLOAT UNSIGNED NOT NULL;
2021 Warnings:
2022 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
2023 SHOW TABLES;
2024 Tables_in_test
2025 t4
2026 SHOW CREATE TABLE t4;
2027 Table Create Table
2028 t4 CREATE TABLE `t4` (
2029 `c1` float unsigned NOT NULL
2030 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2031 DROP TABLE t4;
2032 SHOW TABLES;
2033 Tables_in_test
2034 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NOT NULL);
2035 Warnings:
2036 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
2037 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
2038 SHOW TABLES;
2039 Tables_in_test
2040 t4
2041 SHOW CREATE TABLE t4;
2042 Table Create Table
2043 t4 CREATE TABLE `t4` (
2044 `c1` decimal(10,0) unsigned zerofill NOT NULL
2045 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2046 ALTER TABLE t4 CHANGE c1 c1 DECIMAL UNSIGNED NOT NULL;
2047 Warnings:
2048 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
2049 SHOW TABLES;
2050 Tables_in_test
2051 t4
2052 SHOW CREATE TABLE t4;
2053 Table Create Table
2054 t4 CREATE TABLE `t4` (
2055 `c1` decimal(10,0) unsigned NOT NULL
2056 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2057 DROP TABLE t4;
2058 SHOW TABLES;
2059 Tables_in_test
2060 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NOT NULL);
2061 Warnings:
2062 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
2063 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
2064 SHOW TABLES;
2065 Tables_in_test
2066 t4
2067 SHOW CREATE TABLE t4;
2068 Table Create Table
2069 t4 CREATE TABLE `t4` (
2070 `c1` decimal(10,0) unsigned zerofill NOT NULL
2071 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2072 ALTER TABLE t4 CHANGE c1 c1 NUMERIC UNSIGNED NOT NULL;
2073 Warnings:
2074 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
2075 SHOW TABLES;
2076 Tables_in_test
2077 t4
2078 SHOW CREATE TABLE t4;
2079 Table Create Table
2080 t4 CREATE TABLE `t4` (
2081 `c1` decimal(10,0) unsigned NOT NULL
2082 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2083 DROP TABLE t4;
2084 SHOW TABLES;
2085 Tables_in_test