Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t4;
2 CREATE TABLE t4(c1 TINYINT NULL);
3 SHOW TABLES;
4 Tables_in_test
5 t4
6 SHOW CREATE TABLE t4;
7 Table Create Table
8 t4 CREATE TABLE `t4` (
9 `c1` tinyint DEFAULT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
11 ALTER TABLE t4 MODIFY c1 TINYINT ZEROFILL NULL;
12 Warnings:
13 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.
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(3) unsigned zerofill 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 NULL);
26 SHOW TABLES;
27 Tables_in_test
28 t4
29 SHOW CREATE TABLE t4;
30 Table Create Table
31 t4 CREATE TABLE `t4` (
32 `c1` smallint DEFAULT NULL
33 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
34 ALTER TABLE t4 MODIFY c1 SMALLINT ZEROFILL NULL;
35 Warnings:
36 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.
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(5) unsigned zerofill 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 NULL);
49 SHOW TABLES;
50 Tables_in_test
51 t4
52 SHOW CREATE TABLE t4;
53 Table Create Table
54 t4 CREATE TABLE `t4` (
55 `c1` mediumint DEFAULT NULL
56 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
57 ALTER TABLE t4 MODIFY c1 MEDIUMINT ZEROFILL NULL;
58 Warnings:
59 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.
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(8) unsigned zerofill 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 NULL);
72 SHOW TABLES;
73 Tables_in_test
74 t4
75 SHOW CREATE TABLE t4;
76 Table Create Table
77 t4 CREATE TABLE `t4` (
78 `c1` int DEFAULT NULL
79 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
80 ALTER TABLE t4 MODIFY c1 INT ZEROFILL NULL;
81 Warnings:
82 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.
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(10) unsigned zerofill 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 NULL);
95 SHOW TABLES;
96 Tables_in_test
97 t4
98 SHOW CREATE TABLE t4;
99 Table Create Table
100 t4 CREATE TABLE `t4` (
101 `c1` int DEFAULT NULL
102 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
103 ALTER TABLE t4 MODIFY c1 INTEGER ZEROFILL NULL;
104 Warnings:
105 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.
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(10) unsigned zerofill 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 NULL);
118 SHOW TABLES;
119 Tables_in_test
120 t4
121 SHOW CREATE TABLE t4;
122 Table Create Table
123 t4 CREATE TABLE `t4` (
124 `c1` bigint DEFAULT NULL
125 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
126 ALTER TABLE t4 MODIFY c1 BIGINT ZEROFILL NULL;
127 Warnings:
128 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.
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(20) unsigned zerofill 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 NULL);
141 SHOW TABLES;
142 Tables_in_test
143 t4
144 SHOW CREATE TABLE t4;
145 Table Create Table
146 t4 CREATE TABLE `t4` (
147 `c1` double DEFAULT NULL
148 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
149 ALTER TABLE t4 MODIFY c1 REAL ZEROFILL NULL;
150 Warnings:
151 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.
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 unsigned zerofill 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 NULL);
164 SHOW TABLES;
165 Tables_in_test
166 t4
167 SHOW CREATE TABLE t4;
168 Table Create Table
169 t4 CREATE TABLE `t4` (
170 `c1` double DEFAULT NULL
171 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
172 ALTER TABLE t4 MODIFY c1 DOUBLE ZEROFILL NULL;
173 Warnings:
174 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.
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 unsigned zerofill 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 NULL);
187 SHOW TABLES;
188 Tables_in_test
189 t4
190 SHOW CREATE TABLE t4;
191 Table Create Table
192 t4 CREATE TABLE `t4` (
193 `c1` float DEFAULT NULL
194 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
195 ALTER TABLE t4 MODIFY c1 FLOAT ZEROFILL NULL;
196 Warnings:
197 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.
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 unsigned zerofill 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 NULL);
210 SHOW TABLES;
211 Tables_in_test
212 t4
213 SHOW CREATE TABLE t4;
214 Table Create Table
215 t4 CREATE TABLE `t4` (
216 `c1` decimal(10,0) DEFAULT NULL
217 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
218 ALTER TABLE t4 MODIFY c1 DECIMAL ZEROFILL NULL;
219 Warnings:
220 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.
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) unsigned zerofill 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 NULL);
233 SHOW TABLES;
234 Tables_in_test
235 t4
236 SHOW CREATE TABLE t4;
237 Table Create Table
238 t4 CREATE TABLE `t4` (
239 `c1` decimal(10,0) DEFAULT NULL
240 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
241 ALTER TABLE t4 MODIFY c1 NUMERIC ZEROFILL NULL;
242 Warnings:
243 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.
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) unsigned zerofill 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 NULL);
256 SHOW TABLES;
257 Tables_in_test
258 t4
259 SHOW CREATE TABLE t4;
260 Table Create Table
261 t4 CREATE TABLE `t4` (
262 `c1` tinyint DEFAULT NULL
263 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
264 ALTER TABLE t4 CHANGE c1 c1 TINYINT ZEROFILL NULL;
265 Warnings:
266 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.
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(3) unsigned zerofill 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 NULL);
279 SHOW TABLES;
280 Tables_in_test
281 t4
282 SHOW CREATE TABLE t4;
283 Table Create Table
284 t4 CREATE TABLE `t4` (
285 `c1` smallint DEFAULT NULL
286 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
287 ALTER TABLE t4 CHANGE c1 c1 SMALLINT ZEROFILL NULL;
288 Warnings:
289 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.
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(5) unsigned zerofill 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 NULL);
302 SHOW TABLES;
303 Tables_in_test
304 t4
305 SHOW CREATE TABLE t4;
306 Table Create Table
307 t4 CREATE TABLE `t4` (
308 `c1` mediumint DEFAULT NULL
309 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
310 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT ZEROFILL NULL;
311 Warnings:
312 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.
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(8) unsigned zerofill 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 NULL);
325 SHOW TABLES;
326 Tables_in_test
327 t4
328 SHOW CREATE TABLE t4;
329 Table Create Table
330 t4 CREATE TABLE `t4` (
331 `c1` int DEFAULT NULL
332 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
333 ALTER TABLE t4 CHANGE c1 c1 INT ZEROFILL NULL;
334 Warnings:
335 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.
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(10) unsigned zerofill 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 NULL);
348 SHOW TABLES;
349 Tables_in_test
350 t4
351 SHOW CREATE TABLE t4;
352 Table Create Table
353 t4 CREATE TABLE `t4` (
354 `c1` int DEFAULT NULL
355 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
356 ALTER TABLE t4 CHANGE c1 c1 INTEGER ZEROFILL NULL;
357 Warnings:
358 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.
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(10) unsigned zerofill 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 NULL);
371 SHOW TABLES;
372 Tables_in_test
373 t4
374 SHOW CREATE TABLE t4;
375 Table Create Table
376 t4 CREATE TABLE `t4` (
377 `c1` bigint DEFAULT NULL
378 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
379 ALTER TABLE t4 CHANGE c1 c1 BIGINT ZEROFILL NULL;
380 Warnings:
381 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.
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(20) unsigned zerofill 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 NULL);
394 SHOW TABLES;
395 Tables_in_test
396 t4
397 SHOW CREATE TABLE t4;
398 Table Create Table
399 t4 CREATE TABLE `t4` (
400 `c1` double DEFAULT NULL
401 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
402 ALTER TABLE t4 CHANGE c1 c1 REAL ZEROFILL NULL;
403 Warnings:
404 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.
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 unsigned zerofill 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 NULL);
417 SHOW TABLES;
418 Tables_in_test
419 t4
420 SHOW CREATE TABLE t4;
421 Table Create Table
422 t4 CREATE TABLE `t4` (
423 `c1` double DEFAULT NULL
424 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
425 ALTER TABLE t4 CHANGE c1 c1 DOUBLE ZEROFILL NULL;
426 Warnings:
427 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.
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 unsigned zerofill 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 NULL);
440 SHOW TABLES;
441 Tables_in_test
442 t4
443 SHOW CREATE TABLE t4;
444 Table Create Table
445 t4 CREATE TABLE `t4` (
446 `c1` float DEFAULT NULL
447 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
448 ALTER TABLE t4 CHANGE c1 c1 FLOAT ZEROFILL NULL;
449 Warnings:
450 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.
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 unsigned zerofill 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 NULL);
463 SHOW TABLES;
464 Tables_in_test
465 t4
466 SHOW CREATE TABLE t4;
467 Table Create Table
468 t4 CREATE TABLE `t4` (
469 `c1` decimal(10,0) DEFAULT NULL
470 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
471 ALTER TABLE t4 CHANGE c1 c1 DECIMAL ZEROFILL NULL;
472 Warnings:
473 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.
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) unsigned zerofill 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 NULL);
486 SHOW TABLES;
487 Tables_in_test
488 t4
489 SHOW CREATE TABLE t4;
490 Table Create Table
491 t4 CREATE TABLE `t4` (
492 `c1` decimal(10,0) DEFAULT NULL
493 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
494 ALTER TABLE t4 CHANGE c1 c1 NUMERIC ZEROFILL NULL;
495 Warnings:
496 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.
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) unsigned zerofill 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 NULL);
509 SHOW TABLES;
510 Tables_in_test
511 t4
512 SHOW CREATE TABLE t4;
513 Table Create Table
514 t4 CREATE TABLE `t4` (
515 `c1` tinyint unsigned DEFAULT NULL
516 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
517 ALTER TABLE t4 MODIFY c1 TINYINT UNSIGNED ZEROFILL NULL;
518 Warnings:
519 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.
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(3) unsigned zerofill 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 NULL);
532 SHOW TABLES;
533 Tables_in_test
534 t4
535 SHOW CREATE TABLE t4;
536 Table Create Table
537 t4 CREATE TABLE `t4` (
538 `c1` smallint unsigned DEFAULT NULL
539 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
540 ALTER TABLE t4 MODIFY c1 SMALLINT UNSIGNED ZEROFILL NULL;
541 Warnings:
542 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.
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(5) unsigned zerofill 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 NULL);
555 SHOW TABLES;
556 Tables_in_test
557 t4
558 SHOW CREATE TABLE t4;
559 Table Create Table
560 t4 CREATE TABLE `t4` (
561 `c1` mediumint unsigned DEFAULT NULL
562 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
563 ALTER TABLE t4 MODIFY c1 MEDIUMINT UNSIGNED ZEROFILL NULL;
564 Warnings:
565 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.
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(8) unsigned zerofill 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 NULL);
578 SHOW TABLES;
579 Tables_in_test
580 t4
581 SHOW CREATE TABLE t4;
582 Table Create Table
583 t4 CREATE TABLE `t4` (
584 `c1` int unsigned DEFAULT NULL
585 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
586 ALTER TABLE t4 MODIFY c1 INT UNSIGNED ZEROFILL NULL;
587 Warnings:
588 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.
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(10) unsigned zerofill 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 NULL);
601 SHOW TABLES;
602 Tables_in_test
603 t4
604 SHOW CREATE TABLE t4;
605 Table Create Table
606 t4 CREATE TABLE `t4` (
607 `c1` int unsigned DEFAULT NULL
608 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
609 ALTER TABLE t4 MODIFY c1 INTEGER UNSIGNED ZEROFILL NULL;
610 Warnings:
611 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.
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(10) unsigned zerofill 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 NULL);
624 SHOW TABLES;
625 Tables_in_test
626 t4
627 SHOW CREATE TABLE t4;
628 Table Create Table
629 t4 CREATE TABLE `t4` (
630 `c1` bigint unsigned DEFAULT NULL
631 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
632 ALTER TABLE t4 MODIFY c1 BIGINT UNSIGNED ZEROFILL NULL;
633 Warnings:
634 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.
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(20) unsigned zerofill 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 NULL);
647 Warnings:
648 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
649 SHOW TABLES;
650 Tables_in_test
651 t4
652 SHOW CREATE TABLE t4;
653 Table Create Table
654 t4 CREATE TABLE `t4` (
655 `c1` double unsigned DEFAULT NULL
656 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
657 ALTER TABLE t4 MODIFY c1 REAL UNSIGNED ZEROFILL NULL;
658 Warnings:
659 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.
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 zerofill 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 NULL);
673 Warnings:
674 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
675 SHOW TABLES;
676 Tables_in_test
677 t4
678 SHOW CREATE TABLE t4;
679 Table Create Table
680 t4 CREATE TABLE `t4` (
681 `c1` double unsigned DEFAULT NULL
682 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
683 ALTER TABLE t4 MODIFY c1 DOUBLE UNSIGNED ZEROFILL NULL;
684 Warnings:
685 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.
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 zerofill 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 NULL);
699 Warnings:
700 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
701 SHOW TABLES;
702 Tables_in_test
703 t4
704 SHOW CREATE TABLE t4;
705 Table Create Table
706 t4 CREATE TABLE `t4` (
707 `c1` float unsigned DEFAULT NULL
708 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
709 ALTER TABLE t4 MODIFY c1 FLOAT UNSIGNED ZEROFILL NULL;
710 Warnings:
711 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.
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 zerofill 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 NULL);
725 Warnings:
726 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
727 SHOW TABLES;
728 Tables_in_test
729 t4
730 SHOW CREATE TABLE t4;
731 Table Create Table
732 t4 CREATE TABLE `t4` (
733 `c1` decimal(10,0) unsigned DEFAULT NULL
734 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
735 ALTER TABLE t4 MODIFY c1 DECIMAL UNSIGNED ZEROFILL NULL;
736 Warnings:
737 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.
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 zerofill 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 NULL);
751 Warnings:
752 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
753 SHOW TABLES;
754 Tables_in_test
755 t4
756 SHOW CREATE TABLE t4;
757 Table Create Table
758 t4 CREATE TABLE `t4` (
759 `c1` decimal(10,0) unsigned DEFAULT NULL
760 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
761 ALTER TABLE t4 MODIFY c1 NUMERIC UNSIGNED ZEROFILL NULL;
762 Warnings:
763 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.
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 zerofill 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 NULL);
777 SHOW TABLES;
778 Tables_in_test
779 t4
780 SHOW CREATE TABLE t4;
781 Table Create Table
782 t4 CREATE TABLE `t4` (
783 `c1` tinyint unsigned DEFAULT NULL
784 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
785 ALTER TABLE t4 CHANGE c1 c1 TINYINT UNSIGNED ZEROFILL NULL;
786 Warnings:
787 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.
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(3) unsigned zerofill 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 NULL);
800 SHOW TABLES;
801 Tables_in_test
802 t4
803 SHOW CREATE TABLE t4;
804 Table Create Table
805 t4 CREATE TABLE `t4` (
806 `c1` smallint unsigned DEFAULT NULL
807 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
808 ALTER TABLE t4 CHANGE c1 c1 SMALLINT UNSIGNED ZEROFILL NULL;
809 Warnings:
810 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.
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(5) unsigned zerofill 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 NULL);
823 SHOW TABLES;
824 Tables_in_test
825 t4
826 SHOW CREATE TABLE t4;
827 Table Create Table
828 t4 CREATE TABLE `t4` (
829 `c1` mediumint unsigned DEFAULT NULL
830 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
831 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT UNSIGNED ZEROFILL NULL;
832 Warnings:
833 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.
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(8) unsigned zerofill 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 NULL);
846 SHOW TABLES;
847 Tables_in_test
848 t4
849 SHOW CREATE TABLE t4;
850 Table Create Table
851 t4 CREATE TABLE `t4` (
852 `c1` int unsigned DEFAULT NULL
853 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
854 ALTER TABLE t4 CHANGE c1 c1 INT UNSIGNED ZEROFILL NULL;
855 Warnings:
856 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.
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(10) unsigned zerofill 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 NULL);
869 SHOW TABLES;
870 Tables_in_test
871 t4
872 SHOW CREATE TABLE t4;
873 Table Create Table
874 t4 CREATE TABLE `t4` (
875 `c1` int unsigned DEFAULT NULL
876 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
877 ALTER TABLE t4 CHANGE c1 c1 INTEGER UNSIGNED ZEROFILL NULL;
878 Warnings:
879 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.
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(10) unsigned zerofill 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 NULL);
892 SHOW TABLES;
893 Tables_in_test
894 t4
895 SHOW CREATE TABLE t4;
896 Table Create Table
897 t4 CREATE TABLE `t4` (
898 `c1` bigint unsigned DEFAULT NULL
899 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
900 ALTER TABLE t4 CHANGE c1 c1 BIGINT UNSIGNED ZEROFILL NULL;
901 Warnings:
902 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.
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(20) unsigned zerofill 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 NULL);
915 Warnings:
916 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
917 SHOW TABLES;
918 Tables_in_test
919 t4
920 SHOW CREATE TABLE t4;
921 Table Create Table
922 t4 CREATE TABLE `t4` (
923 `c1` double unsigned DEFAULT NULL
924 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
925 ALTER TABLE t4 CHANGE c1 c1 REAL UNSIGNED ZEROFILL NULL;
926 Warnings:
927 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.
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 zerofill 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 NULL);
941 Warnings:
942 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
943 SHOW TABLES;
944 Tables_in_test
945 t4
946 SHOW CREATE TABLE t4;
947 Table Create Table
948 t4 CREATE TABLE `t4` (
949 `c1` double unsigned DEFAULT NULL
950 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
951 ALTER TABLE t4 CHANGE c1 c1 DOUBLE UNSIGNED ZEROFILL NULL;
952 Warnings:
953 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.
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 zerofill 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 NULL);
967 Warnings:
968 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
969 SHOW TABLES;
970 Tables_in_test
971 t4
972 SHOW CREATE TABLE t4;
973 Table Create Table
974 t4 CREATE TABLE `t4` (
975 `c1` float unsigned DEFAULT NULL
976 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
977 ALTER TABLE t4 CHANGE c1 c1 FLOAT UNSIGNED ZEROFILL NULL;
978 Warnings:
979 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.
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 zerofill 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 NULL);
993 Warnings:
994 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
995 SHOW TABLES;
996 Tables_in_test
997 t4
998 SHOW CREATE TABLE t4;
999 Table Create Table
1000 t4 CREATE TABLE `t4` (
1001 `c1` decimal(10,0) unsigned DEFAULT NULL
1002 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1003 ALTER TABLE t4 CHANGE c1 c1 DECIMAL UNSIGNED ZEROFILL NULL;
1004 Warnings:
1005 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.
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 zerofill 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 NULL);
1019 Warnings:
1020 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1021 SHOW TABLES;
1022 Tables_in_test
1023 t4
1024 SHOW CREATE TABLE t4;
1025 Table Create Table
1026 t4 CREATE TABLE `t4` (
1027 `c1` decimal(10,0) unsigned DEFAULT NULL
1028 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1029 ALTER TABLE t4 CHANGE c1 c1 NUMERIC UNSIGNED ZEROFILL NULL;
1030 Warnings:
1031 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.
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 zerofill 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 NOT NULL);
1045 SHOW TABLES;
1046 Tables_in_test
1047 t4
1048 SHOW CREATE TABLE t4;
1049 Table Create Table
1050 t4 CREATE TABLE `t4` (
1051 `c1` tinyint NOT NULL
1052 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1053 ALTER TABLE t4 MODIFY c1 TINYINT ZEROFILL NOT NULL;
1054 Warnings:
1055 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.
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(3) unsigned zerofill 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 NOT NULL);
1068 SHOW TABLES;
1069 Tables_in_test
1070 t4
1071 SHOW CREATE TABLE t4;
1072 Table Create Table
1073 t4 CREATE TABLE `t4` (
1074 `c1` smallint NOT NULL
1075 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1076 ALTER TABLE t4 MODIFY c1 SMALLINT ZEROFILL NOT NULL;
1077 Warnings:
1078 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.
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(5) unsigned zerofill 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 NOT NULL);
1091 SHOW TABLES;
1092 Tables_in_test
1093 t4
1094 SHOW CREATE TABLE t4;
1095 Table Create Table
1096 t4 CREATE TABLE `t4` (
1097 `c1` mediumint NOT NULL
1098 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1099 ALTER TABLE t4 MODIFY c1 MEDIUMINT ZEROFILL NOT NULL;
1100 Warnings:
1101 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.
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(8) unsigned zerofill 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 NOT NULL);
1114 SHOW TABLES;
1115 Tables_in_test
1116 t4
1117 SHOW CREATE TABLE t4;
1118 Table Create Table
1119 t4 CREATE TABLE `t4` (
1120 `c1` int NOT NULL
1121 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1122 ALTER TABLE t4 MODIFY c1 INT ZEROFILL NOT NULL;
1123 Warnings:
1124 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.
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(10) unsigned zerofill 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 NOT NULL);
1137 SHOW TABLES;
1138 Tables_in_test
1139 t4
1140 SHOW CREATE TABLE t4;
1141 Table Create Table
1142 t4 CREATE TABLE `t4` (
1143 `c1` int NOT NULL
1144 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1145 ALTER TABLE t4 MODIFY c1 INTEGER ZEROFILL NOT NULL;
1146 Warnings:
1147 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.
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(10) unsigned zerofill 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 NOT NULL);
1160 SHOW TABLES;
1161 Tables_in_test
1162 t4
1163 SHOW CREATE TABLE t4;
1164 Table Create Table
1165 t4 CREATE TABLE `t4` (
1166 `c1` bigint NOT NULL
1167 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1168 ALTER TABLE t4 MODIFY c1 BIGINT ZEROFILL NOT NULL;
1169 Warnings:
1170 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.
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(20) unsigned zerofill 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 NOT NULL);
1183 SHOW TABLES;
1184 Tables_in_test
1185 t4
1186 SHOW CREATE TABLE t4;
1187 Table Create Table
1188 t4 CREATE TABLE `t4` (
1189 `c1` double NOT NULL
1190 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1191 ALTER TABLE t4 MODIFY c1 REAL ZEROFILL NOT NULL;
1192 Warnings:
1193 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.
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 unsigned zerofill 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 NOT NULL);
1206 SHOW TABLES;
1207 Tables_in_test
1208 t4
1209 SHOW CREATE TABLE t4;
1210 Table Create Table
1211 t4 CREATE TABLE `t4` (
1212 `c1` double NOT NULL
1213 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1214 ALTER TABLE t4 MODIFY c1 DOUBLE ZEROFILL NOT NULL;
1215 Warnings:
1216 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.
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 unsigned zerofill 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 NOT NULL);
1229 SHOW TABLES;
1230 Tables_in_test
1231 t4
1232 SHOW CREATE TABLE t4;
1233 Table Create Table
1234 t4 CREATE TABLE `t4` (
1235 `c1` float NOT NULL
1236 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1237 ALTER TABLE t4 MODIFY c1 FLOAT ZEROFILL NOT NULL;
1238 Warnings:
1239 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.
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 unsigned zerofill 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 NOT NULL);
1252 SHOW TABLES;
1253 Tables_in_test
1254 t4
1255 SHOW CREATE TABLE t4;
1256 Table Create Table
1257 t4 CREATE TABLE `t4` (
1258 `c1` decimal(10,0) NOT NULL
1259 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1260 ALTER TABLE t4 MODIFY c1 DECIMAL ZEROFILL NOT NULL;
1261 Warnings:
1262 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.
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) unsigned zerofill 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 NOT NULL);
1275 SHOW TABLES;
1276 Tables_in_test
1277 t4
1278 SHOW CREATE TABLE t4;
1279 Table Create Table
1280 t4 CREATE TABLE `t4` (
1281 `c1` decimal(10,0) NOT NULL
1282 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1283 ALTER TABLE t4 MODIFY c1 NUMERIC ZEROFILL NOT NULL;
1284 Warnings:
1285 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.
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) unsigned zerofill 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 NOT NULL);
1298 SHOW TABLES;
1299 Tables_in_test
1300 t4
1301 SHOW CREATE TABLE t4;
1302 Table Create Table
1303 t4 CREATE TABLE `t4` (
1304 `c1` tinyint NOT NULL
1305 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1306 ALTER TABLE t4 CHANGE c1 c1 TINYINT ZEROFILL NOT NULL;
1307 Warnings:
1308 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.
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(3) unsigned zerofill 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 NOT NULL);
1321 SHOW TABLES;
1322 Tables_in_test
1323 t4
1324 SHOW CREATE TABLE t4;
1325 Table Create Table
1326 t4 CREATE TABLE `t4` (
1327 `c1` smallint NOT NULL
1328 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1329 ALTER TABLE t4 CHANGE c1 c1 SMALLINT ZEROFILL NOT NULL;
1330 Warnings:
1331 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.
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(5) unsigned zerofill 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 NOT NULL);
1344 SHOW TABLES;
1345 Tables_in_test
1346 t4
1347 SHOW CREATE TABLE t4;
1348 Table Create Table
1349 t4 CREATE TABLE `t4` (
1350 `c1` mediumint NOT NULL
1351 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1352 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT ZEROFILL NOT NULL;
1353 Warnings:
1354 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.
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(8) unsigned zerofill 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 NOT NULL);
1367 SHOW TABLES;
1368 Tables_in_test
1369 t4
1370 SHOW CREATE TABLE t4;
1371 Table Create Table
1372 t4 CREATE TABLE `t4` (
1373 `c1` int NOT NULL
1374 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1375 ALTER TABLE t4 CHANGE c1 c1 INT ZEROFILL NOT NULL;
1376 Warnings:
1377 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.
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(10) unsigned zerofill 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 NOT NULL);
1390 SHOW TABLES;
1391 Tables_in_test
1392 t4
1393 SHOW CREATE TABLE t4;
1394 Table Create Table
1395 t4 CREATE TABLE `t4` (
1396 `c1` int NOT NULL
1397 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1398 ALTER TABLE t4 CHANGE c1 c1 INTEGER ZEROFILL NOT NULL;
1399 Warnings:
1400 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.
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(10) unsigned zerofill 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 NOT NULL);
1413 SHOW TABLES;
1414 Tables_in_test
1415 t4
1416 SHOW CREATE TABLE t4;
1417 Table Create Table
1418 t4 CREATE TABLE `t4` (
1419 `c1` bigint NOT NULL
1420 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1421 ALTER TABLE t4 CHANGE c1 c1 BIGINT ZEROFILL NOT NULL;
1422 Warnings:
1423 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.
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(20) unsigned zerofill 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 NOT NULL);
1436 SHOW TABLES;
1437 Tables_in_test
1438 t4
1439 SHOW CREATE TABLE t4;
1440 Table Create Table
1441 t4 CREATE TABLE `t4` (
1442 `c1` double NOT NULL
1443 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1444 ALTER TABLE t4 CHANGE c1 c1 REAL ZEROFILL NOT NULL;
1445 Warnings:
1446 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.
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 unsigned zerofill 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 NOT NULL);
1459 SHOW TABLES;
1460 Tables_in_test
1461 t4
1462 SHOW CREATE TABLE t4;
1463 Table Create Table
1464 t4 CREATE TABLE `t4` (
1465 `c1` double NOT NULL
1466 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1467 ALTER TABLE t4 CHANGE c1 c1 DOUBLE ZEROFILL NOT NULL;
1468 Warnings:
1469 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.
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 unsigned zerofill 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 NOT NULL);
1482 SHOW TABLES;
1483 Tables_in_test
1484 t4
1485 SHOW CREATE TABLE t4;
1486 Table Create Table
1487 t4 CREATE TABLE `t4` (
1488 `c1` float NOT NULL
1489 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1490 ALTER TABLE t4 CHANGE c1 c1 FLOAT ZEROFILL NOT NULL;
1491 Warnings:
1492 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.
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 unsigned zerofill 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 NOT NULL);
1505 SHOW TABLES;
1506 Tables_in_test
1507 t4
1508 SHOW CREATE TABLE t4;
1509 Table Create Table
1510 t4 CREATE TABLE `t4` (
1511 `c1` decimal(10,0) NOT NULL
1512 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1513 ALTER TABLE t4 CHANGE c1 c1 DECIMAL ZEROFILL NOT NULL;
1514 Warnings:
1515 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.
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) unsigned zerofill 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 NOT NULL);
1528 SHOW TABLES;
1529 Tables_in_test
1530 t4
1531 SHOW CREATE TABLE t4;
1532 Table Create Table
1533 t4 CREATE TABLE `t4` (
1534 `c1` decimal(10,0) NOT NULL
1535 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1536 ALTER TABLE t4 CHANGE c1 c1 NUMERIC ZEROFILL NOT NULL;
1537 Warnings:
1538 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.
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) unsigned zerofill 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 NOT NULL);
1551 SHOW TABLES;
1552 Tables_in_test
1553 t4
1554 SHOW CREATE TABLE t4;
1555 Table Create Table
1556 t4 CREATE TABLE `t4` (
1557 `c1` tinyint unsigned NOT NULL
1558 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1559 ALTER TABLE t4 MODIFY c1 TINYINT UNSIGNED ZEROFILL NOT NULL;
1560 Warnings:
1561 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.
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(3) unsigned zerofill 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 NOT NULL);
1574 SHOW TABLES;
1575 Tables_in_test
1576 t4
1577 SHOW CREATE TABLE t4;
1578 Table Create Table
1579 t4 CREATE TABLE `t4` (
1580 `c1` smallint unsigned NOT NULL
1581 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1582 ALTER TABLE t4 MODIFY c1 SMALLINT UNSIGNED ZEROFILL NOT NULL;
1583 Warnings:
1584 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.
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(5) unsigned zerofill 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 NOT NULL);
1597 SHOW TABLES;
1598 Tables_in_test
1599 t4
1600 SHOW CREATE TABLE t4;
1601 Table Create Table
1602 t4 CREATE TABLE `t4` (
1603 `c1` mediumint unsigned NOT NULL
1604 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1605 ALTER TABLE t4 MODIFY c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL;
1606 Warnings:
1607 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.
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(8) unsigned zerofill 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 NOT NULL);
1620 SHOW TABLES;
1621 Tables_in_test
1622 t4
1623 SHOW CREATE TABLE t4;
1624 Table Create Table
1625 t4 CREATE TABLE `t4` (
1626 `c1` int unsigned NOT NULL
1627 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1628 ALTER TABLE t4 MODIFY c1 INT UNSIGNED ZEROFILL NOT NULL;
1629 Warnings:
1630 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.
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(10) unsigned zerofill 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 NOT NULL);
1643 SHOW TABLES;
1644 Tables_in_test
1645 t4
1646 SHOW CREATE TABLE t4;
1647 Table Create Table
1648 t4 CREATE TABLE `t4` (
1649 `c1` int unsigned NOT NULL
1650 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1651 ALTER TABLE t4 MODIFY c1 INTEGER UNSIGNED ZEROFILL NOT NULL;
1652 Warnings:
1653 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.
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(10) unsigned zerofill 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 NOT NULL);
1666 SHOW TABLES;
1667 Tables_in_test
1668 t4
1669 SHOW CREATE TABLE t4;
1670 Table Create Table
1671 t4 CREATE TABLE `t4` (
1672 `c1` bigint unsigned NOT NULL
1673 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1674 ALTER TABLE t4 MODIFY c1 BIGINT UNSIGNED ZEROFILL NOT NULL;
1675 Warnings:
1676 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.
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(20) unsigned zerofill 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 NOT NULL);
1689 Warnings:
1690 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1691 SHOW TABLES;
1692 Tables_in_test
1693 t4
1694 SHOW CREATE TABLE t4;
1695 Table Create Table
1696 t4 CREATE TABLE `t4` (
1697 `c1` double unsigned NOT NULL
1698 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1699 ALTER TABLE t4 MODIFY c1 REAL UNSIGNED ZEROFILL NOT NULL;
1700 Warnings:
1701 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.
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 zerofill 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 NOT NULL);
1715 Warnings:
1716 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1717 SHOW TABLES;
1718 Tables_in_test
1719 t4
1720 SHOW CREATE TABLE t4;
1721 Table Create Table
1722 t4 CREATE TABLE `t4` (
1723 `c1` double unsigned NOT NULL
1724 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1725 ALTER TABLE t4 MODIFY c1 DOUBLE UNSIGNED ZEROFILL NOT NULL;
1726 Warnings:
1727 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.
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 zerofill 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 NOT NULL);
1741 Warnings:
1742 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1743 SHOW TABLES;
1744 Tables_in_test
1745 t4
1746 SHOW CREATE TABLE t4;
1747 Table Create Table
1748 t4 CREATE TABLE `t4` (
1749 `c1` float unsigned NOT NULL
1750 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1751 ALTER TABLE t4 MODIFY c1 FLOAT UNSIGNED ZEROFILL NOT NULL;
1752 Warnings:
1753 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.
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 zerofill 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 NOT NULL);
1767 Warnings:
1768 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1769 SHOW TABLES;
1770 Tables_in_test
1771 t4
1772 SHOW CREATE TABLE t4;
1773 Table Create Table
1774 t4 CREATE TABLE `t4` (
1775 `c1` decimal(10,0) unsigned NOT NULL
1776 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1777 ALTER TABLE t4 MODIFY c1 DECIMAL UNSIGNED ZEROFILL NOT NULL;
1778 Warnings:
1779 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.
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 zerofill 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 NOT NULL);
1793 Warnings:
1794 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1795 SHOW TABLES;
1796 Tables_in_test
1797 t4
1798 SHOW CREATE TABLE t4;
1799 Table Create Table
1800 t4 CREATE TABLE `t4` (
1801 `c1` decimal(10,0) unsigned NOT NULL
1802 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1803 ALTER TABLE t4 MODIFY c1 NUMERIC UNSIGNED ZEROFILL NOT NULL;
1804 Warnings:
1805 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.
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 zerofill 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 NOT NULL);
1819 SHOW TABLES;
1820 Tables_in_test
1821 t4
1822 SHOW CREATE TABLE t4;
1823 Table Create Table
1824 t4 CREATE TABLE `t4` (
1825 `c1` tinyint unsigned NOT NULL
1826 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1827 ALTER TABLE t4 CHANGE c1 c1 TINYINT UNSIGNED ZEROFILL NOT NULL;
1828 Warnings:
1829 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.
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(3) unsigned zerofill 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 NOT NULL);
1842 SHOW TABLES;
1843 Tables_in_test
1844 t4
1845 SHOW CREATE TABLE t4;
1846 Table Create Table
1847 t4 CREATE TABLE `t4` (
1848 `c1` smallint unsigned NOT NULL
1849 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1850 ALTER TABLE t4 CHANGE c1 c1 SMALLINT UNSIGNED ZEROFILL NOT NULL;
1851 Warnings:
1852 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.
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(5) unsigned zerofill 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 NOT NULL);
1865 SHOW TABLES;
1866 Tables_in_test
1867 t4
1868 SHOW CREATE TABLE t4;
1869 Table Create Table
1870 t4 CREATE TABLE `t4` (
1871 `c1` mediumint unsigned NOT NULL
1872 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1873 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL;
1874 Warnings:
1875 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.
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(8) unsigned zerofill 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 NOT NULL);
1888 SHOW TABLES;
1889 Tables_in_test
1890 t4
1891 SHOW CREATE TABLE t4;
1892 Table Create Table
1893 t4 CREATE TABLE `t4` (
1894 `c1` int unsigned NOT NULL
1895 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1896 ALTER TABLE t4 CHANGE c1 c1 INT UNSIGNED ZEROFILL NOT NULL;
1897 Warnings:
1898 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.
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(10) unsigned zerofill 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 NOT NULL);
1911 SHOW TABLES;
1912 Tables_in_test
1913 t4
1914 SHOW CREATE TABLE t4;
1915 Table Create Table
1916 t4 CREATE TABLE `t4` (
1917 `c1` int unsigned NOT NULL
1918 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1919 ALTER TABLE t4 CHANGE c1 c1 INTEGER UNSIGNED ZEROFILL NOT NULL;
1920 Warnings:
1921 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.
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(10) unsigned zerofill 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 NOT NULL);
1934 SHOW TABLES;
1935 Tables_in_test
1936 t4
1937 SHOW CREATE TABLE t4;
1938 Table Create Table
1939 t4 CREATE TABLE `t4` (
1940 `c1` bigint unsigned NOT NULL
1941 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1942 ALTER TABLE t4 CHANGE c1 c1 BIGINT UNSIGNED ZEROFILL NOT NULL;
1943 Warnings:
1944 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.
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(20) unsigned zerofill 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 NOT NULL);
1957 Warnings:
1958 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1959 SHOW TABLES;
1960 Tables_in_test
1961 t4
1962 SHOW CREATE TABLE t4;
1963 Table Create Table
1964 t4 CREATE TABLE `t4` (
1965 `c1` double unsigned NOT NULL
1966 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1967 ALTER TABLE t4 CHANGE c1 c1 REAL UNSIGNED ZEROFILL NOT NULL;
1968 Warnings:
1969 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.
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 zerofill 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 NOT NULL);
1983 Warnings:
1984 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1985 SHOW TABLES;
1986 Tables_in_test
1987 t4
1988 SHOW CREATE TABLE t4;
1989 Table Create Table
1990 t4 CREATE TABLE `t4` (
1991 `c1` double unsigned NOT NULL
1992 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1993 ALTER TABLE t4 CHANGE c1 c1 DOUBLE UNSIGNED ZEROFILL NOT NULL;
1994 Warnings:
1995 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.
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 zerofill 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 NOT NULL);
2009 Warnings:
2010 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
2011 SHOW TABLES;
2012 Tables_in_test
2013 t4
2014 SHOW CREATE TABLE t4;
2015 Table Create Table
2016 t4 CREATE TABLE `t4` (
2017 `c1` float unsigned NOT NULL
2018 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2019 ALTER TABLE t4 CHANGE c1 c1 FLOAT UNSIGNED ZEROFILL NOT NULL;
2020 Warnings:
2021 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.
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 zerofill 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 NOT NULL);
2035 Warnings:
2036 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
2037 SHOW TABLES;
2038 Tables_in_test
2039 t4
2040 SHOW CREATE TABLE t4;
2041 Table Create Table
2042 t4 CREATE TABLE `t4` (
2043 `c1` decimal(10,0) unsigned NOT NULL
2044 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2045 ALTER TABLE t4 CHANGE c1 c1 DECIMAL UNSIGNED ZEROFILL NOT NULL;
2046 Warnings:
2047 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.
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 zerofill 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 NOT NULL);
2061 Warnings:
2062 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
2063 SHOW TABLES;
2064 Tables_in_test
2065 t4
2066 SHOW CREATE TABLE t4;
2067 Table Create Table
2068 t4 CREATE TABLE `t4` (
2069 `c1` decimal(10,0) unsigned NOT NULL
2070 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2071 ALTER TABLE t4 CHANGE c1 c1 NUMERIC UNSIGNED ZEROFILL NOT NULL;
2072 Warnings:
2073 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.
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 zerofill NOT NULL
2082 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2083 DROP TABLE t4;
2084 SHOW TABLES;
2085 Tables_in_test