1 DROP TABLE IF EXISTS t4;
2 CREATE TABLE t4(c1 TINYINT ZEROFILL NULL);
9 `c1` tinyint(3) unsigned zerofill DEFAULT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
11 ALTER TABLE t4 MODIFY c1 TINYINT NULL;
17 t4 CREATE TABLE `t4` (
18 `c1` tinyint(4) DEFAULT NULL
19 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
23 CREATE TABLE t4(c1 SMALLINT ZEROFILL NULL);
29 t4 CREATE TABLE `t4` (
30 `c1` smallint(5) unsigned zerofill DEFAULT NULL
31 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
32 ALTER TABLE t4 MODIFY c1 SMALLINT NULL;
38 t4 CREATE TABLE `t4` (
39 `c1` smallint(6) DEFAULT NULL
40 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
44 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NULL);
50 t4 CREATE TABLE `t4` (
51 `c1` mediumint(8) unsigned zerofill DEFAULT NULL
52 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
53 ALTER TABLE t4 MODIFY c1 MEDIUMINT NULL;
59 t4 CREATE TABLE `t4` (
60 `c1` mediumint(9) DEFAULT NULL
61 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
65 CREATE TABLE t4(c1 INT ZEROFILL NULL);
71 t4 CREATE TABLE `t4` (
72 `c1` int(10) unsigned zerofill DEFAULT NULL
73 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
74 ALTER TABLE t4 MODIFY c1 INT NULL;
80 t4 CREATE TABLE `t4` (
81 `c1` int(11) DEFAULT NULL
82 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
86 CREATE TABLE t4(c1 INTEGER ZEROFILL NULL);
92 t4 CREATE TABLE `t4` (
93 `c1` int(10) unsigned zerofill DEFAULT NULL
94 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
95 ALTER TABLE t4 MODIFY c1 INTEGER NULL;
101 t4 CREATE TABLE `t4` (
102 `c1` int(11) DEFAULT NULL
103 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
107 CREATE TABLE t4(c1 BIGINT ZEROFILL NULL);
111 SHOW CREATE TABLE t4;
113 t4 CREATE TABLE `t4` (
114 `c1` bigint(20) unsigned zerofill DEFAULT NULL
115 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
116 ALTER TABLE t4 MODIFY c1 BIGINT NULL;
120 SHOW CREATE TABLE t4;
122 t4 CREATE TABLE `t4` (
123 `c1` bigint(20) DEFAULT NULL
124 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
128 CREATE TABLE t4(c1 REAL ZEROFILL NULL);
132 SHOW CREATE TABLE t4;
134 t4 CREATE TABLE `t4` (
135 `c1` double unsigned zerofill DEFAULT NULL
136 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
137 ALTER TABLE t4 MODIFY c1 REAL NULL;
141 SHOW CREATE TABLE t4;
143 t4 CREATE TABLE `t4` (
144 `c1` double DEFAULT NULL
145 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
149 CREATE TABLE t4(c1 DOUBLE ZEROFILL NULL);
153 SHOW CREATE TABLE t4;
155 t4 CREATE TABLE `t4` (
156 `c1` double unsigned zerofill DEFAULT NULL
157 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
158 ALTER TABLE t4 MODIFY c1 DOUBLE NULL;
162 SHOW CREATE TABLE t4;
164 t4 CREATE TABLE `t4` (
165 `c1` double DEFAULT NULL
166 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
170 CREATE TABLE t4(c1 FLOAT ZEROFILL NULL);
174 SHOW CREATE TABLE t4;
176 t4 CREATE TABLE `t4` (
177 `c1` float unsigned zerofill DEFAULT NULL
178 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
179 ALTER TABLE t4 MODIFY c1 FLOAT NULL;
183 SHOW CREATE TABLE t4;
185 t4 CREATE TABLE `t4` (
186 `c1` float DEFAULT NULL
187 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
191 CREATE TABLE t4(c1 DECIMAL ZEROFILL NULL);
195 SHOW CREATE TABLE t4;
197 t4 CREATE TABLE `t4` (
198 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
199 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
200 ALTER TABLE t4 MODIFY c1 DECIMAL NULL;
204 SHOW CREATE TABLE t4;
206 t4 CREATE TABLE `t4` (
207 `c1` decimal(10,0) DEFAULT NULL
208 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
212 CREATE TABLE t4(c1 NUMERIC ZEROFILL NULL);
216 SHOW CREATE TABLE t4;
218 t4 CREATE TABLE `t4` (
219 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
220 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
221 ALTER TABLE t4 MODIFY c1 NUMERIC NULL;
225 SHOW CREATE TABLE t4;
227 t4 CREATE TABLE `t4` (
228 `c1` decimal(10,0) DEFAULT NULL
229 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
233 CREATE TABLE t4(c1 TINYINT ZEROFILL NULL);
237 SHOW CREATE TABLE t4;
239 t4 CREATE TABLE `t4` (
240 `c1` tinyint(3) unsigned zerofill DEFAULT NULL
241 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
242 ALTER TABLE t4 CHANGE c1 c1 TINYINT NULL;
246 SHOW CREATE TABLE t4;
248 t4 CREATE TABLE `t4` (
249 `c1` tinyint(4) DEFAULT NULL
250 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
254 CREATE TABLE t4(c1 SMALLINT ZEROFILL NULL);
258 SHOW CREATE TABLE t4;
260 t4 CREATE TABLE `t4` (
261 `c1` smallint(5) unsigned zerofill DEFAULT NULL
262 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
263 ALTER TABLE t4 CHANGE c1 c1 SMALLINT NULL;
267 SHOW CREATE TABLE t4;
269 t4 CREATE TABLE `t4` (
270 `c1` smallint(6) DEFAULT NULL
271 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
275 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NULL);
279 SHOW CREATE TABLE t4;
281 t4 CREATE TABLE `t4` (
282 `c1` mediumint(8) unsigned zerofill DEFAULT NULL
283 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
284 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT NULL;
288 SHOW CREATE TABLE t4;
290 t4 CREATE TABLE `t4` (
291 `c1` mediumint(9) DEFAULT NULL
292 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
296 CREATE TABLE t4(c1 INT ZEROFILL NULL);
300 SHOW CREATE TABLE t4;
302 t4 CREATE TABLE `t4` (
303 `c1` int(10) unsigned zerofill DEFAULT NULL
304 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
305 ALTER TABLE t4 CHANGE c1 c1 INT NULL;
309 SHOW CREATE TABLE t4;
311 t4 CREATE TABLE `t4` (
312 `c1` int(11) DEFAULT NULL
313 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
317 CREATE TABLE t4(c1 INTEGER ZEROFILL NULL);
321 SHOW CREATE TABLE t4;
323 t4 CREATE TABLE `t4` (
324 `c1` int(10) unsigned zerofill DEFAULT NULL
325 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
326 ALTER TABLE t4 CHANGE c1 c1 INTEGER NULL;
330 SHOW CREATE TABLE t4;
332 t4 CREATE TABLE `t4` (
333 `c1` int(11) DEFAULT NULL
334 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
338 CREATE TABLE t4(c1 BIGINT ZEROFILL NULL);
342 SHOW CREATE TABLE t4;
344 t4 CREATE TABLE `t4` (
345 `c1` bigint(20) unsigned zerofill DEFAULT NULL
346 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
347 ALTER TABLE t4 CHANGE c1 c1 BIGINT NULL;
351 SHOW CREATE TABLE t4;
353 t4 CREATE TABLE `t4` (
354 `c1` bigint(20) DEFAULT NULL
355 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
359 CREATE TABLE t4(c1 REAL ZEROFILL NULL);
363 SHOW CREATE TABLE t4;
365 t4 CREATE TABLE `t4` (
366 `c1` double unsigned zerofill DEFAULT NULL
367 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
368 ALTER TABLE t4 CHANGE c1 c1 REAL NULL;
372 SHOW CREATE TABLE t4;
374 t4 CREATE TABLE `t4` (
375 `c1` double DEFAULT NULL
376 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
380 CREATE TABLE t4(c1 DOUBLE ZEROFILL NULL);
384 SHOW CREATE TABLE t4;
386 t4 CREATE TABLE `t4` (
387 `c1` double unsigned zerofill DEFAULT NULL
388 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
389 ALTER TABLE t4 CHANGE c1 c1 DOUBLE NULL;
393 SHOW CREATE TABLE t4;
395 t4 CREATE TABLE `t4` (
396 `c1` double DEFAULT NULL
397 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
401 CREATE TABLE t4(c1 FLOAT ZEROFILL NULL);
405 SHOW CREATE TABLE t4;
407 t4 CREATE TABLE `t4` (
408 `c1` float unsigned zerofill DEFAULT NULL
409 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
410 ALTER TABLE t4 CHANGE c1 c1 FLOAT NULL;
414 SHOW CREATE TABLE t4;
416 t4 CREATE TABLE `t4` (
417 `c1` float DEFAULT NULL
418 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
422 CREATE TABLE t4(c1 DECIMAL ZEROFILL NULL);
426 SHOW CREATE TABLE t4;
428 t4 CREATE TABLE `t4` (
429 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
430 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
431 ALTER TABLE t4 CHANGE c1 c1 DECIMAL NULL;
435 SHOW CREATE TABLE t4;
437 t4 CREATE TABLE `t4` (
438 `c1` decimal(10,0) DEFAULT NULL
439 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
443 CREATE TABLE t4(c1 NUMERIC ZEROFILL NULL);
447 SHOW CREATE TABLE t4;
449 t4 CREATE TABLE `t4` (
450 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
451 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
452 ALTER TABLE t4 CHANGE c1 c1 NUMERIC NULL;
456 SHOW CREATE TABLE t4;
458 t4 CREATE TABLE `t4` (
459 `c1` decimal(10,0) DEFAULT NULL
460 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
464 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NULL);
468 SHOW CREATE TABLE t4;
470 t4 CREATE TABLE `t4` (
471 `c1` tinyint(3) unsigned zerofill DEFAULT NULL
472 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
473 ALTER TABLE t4 MODIFY c1 TINYINT UNSIGNED NULL;
477 SHOW CREATE TABLE t4;
479 t4 CREATE TABLE `t4` (
480 `c1` tinyint(3) unsigned DEFAULT NULL
481 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
485 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NULL);
489 SHOW CREATE TABLE t4;
491 t4 CREATE TABLE `t4` (
492 `c1` smallint(5) unsigned zerofill DEFAULT NULL
493 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
494 ALTER TABLE t4 MODIFY c1 SMALLINT UNSIGNED NULL;
498 SHOW CREATE TABLE t4;
500 t4 CREATE TABLE `t4` (
501 `c1` smallint(5) unsigned DEFAULT NULL
502 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
506 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NULL);
510 SHOW CREATE TABLE t4;
512 t4 CREATE TABLE `t4` (
513 `c1` mediumint(8) unsigned zerofill DEFAULT NULL
514 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
515 ALTER TABLE t4 MODIFY c1 MEDIUMINT UNSIGNED NULL;
519 SHOW CREATE TABLE t4;
521 t4 CREATE TABLE `t4` (
522 `c1` mediumint(8) unsigned DEFAULT NULL
523 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
527 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NULL);
531 SHOW CREATE TABLE t4;
533 t4 CREATE TABLE `t4` (
534 `c1` int(10) unsigned zerofill DEFAULT NULL
535 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
536 ALTER TABLE t4 MODIFY c1 INT UNSIGNED NULL;
540 SHOW CREATE TABLE t4;
542 t4 CREATE TABLE `t4` (
543 `c1` int(10) unsigned DEFAULT NULL
544 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
548 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NULL);
552 SHOW CREATE TABLE t4;
554 t4 CREATE TABLE `t4` (
555 `c1` int(10) unsigned zerofill DEFAULT NULL
556 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
557 ALTER TABLE t4 MODIFY c1 INTEGER UNSIGNED NULL;
561 SHOW CREATE TABLE t4;
563 t4 CREATE TABLE `t4` (
564 `c1` int(10) unsigned DEFAULT NULL
565 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
569 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NULL);
573 SHOW CREATE TABLE t4;
575 t4 CREATE TABLE `t4` (
576 `c1` bigint(20) unsigned zerofill DEFAULT NULL
577 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
578 ALTER TABLE t4 MODIFY c1 BIGINT UNSIGNED NULL;
582 SHOW CREATE TABLE t4;
584 t4 CREATE TABLE `t4` (
585 `c1` bigint(20) unsigned DEFAULT NULL
586 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
590 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NULL);
594 SHOW CREATE TABLE t4;
596 t4 CREATE TABLE `t4` (
597 `c1` double unsigned zerofill DEFAULT NULL
598 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
599 ALTER TABLE t4 MODIFY c1 REAL UNSIGNED NULL;
603 SHOW CREATE TABLE t4;
605 t4 CREATE TABLE `t4` (
606 `c1` double unsigned DEFAULT NULL
607 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
611 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NULL);
615 SHOW CREATE TABLE t4;
617 t4 CREATE TABLE `t4` (
618 `c1` double unsigned zerofill DEFAULT NULL
619 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
620 ALTER TABLE t4 MODIFY c1 DOUBLE UNSIGNED NULL;
624 SHOW CREATE TABLE t4;
626 t4 CREATE TABLE `t4` (
627 `c1` double unsigned DEFAULT NULL
628 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
632 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NULL);
636 SHOW CREATE TABLE t4;
638 t4 CREATE TABLE `t4` (
639 `c1` float unsigned zerofill DEFAULT NULL
640 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
641 ALTER TABLE t4 MODIFY c1 FLOAT UNSIGNED NULL;
645 SHOW CREATE TABLE t4;
647 t4 CREATE TABLE `t4` (
648 `c1` float unsigned DEFAULT NULL
649 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
653 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NULL);
657 SHOW CREATE TABLE t4;
659 t4 CREATE TABLE `t4` (
660 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
661 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
662 ALTER TABLE t4 MODIFY c1 DECIMAL UNSIGNED NULL;
666 SHOW CREATE TABLE t4;
668 t4 CREATE TABLE `t4` (
669 `c1` decimal(10,0) unsigned DEFAULT NULL
670 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
674 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NULL);
678 SHOW CREATE TABLE t4;
680 t4 CREATE TABLE `t4` (
681 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
682 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
683 ALTER TABLE t4 MODIFY c1 NUMERIC UNSIGNED NULL;
687 SHOW CREATE TABLE t4;
689 t4 CREATE TABLE `t4` (
690 `c1` decimal(10,0) unsigned DEFAULT NULL
691 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
695 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NULL);
699 SHOW CREATE TABLE t4;
701 t4 CREATE TABLE `t4` (
702 `c1` tinyint(3) unsigned zerofill DEFAULT NULL
703 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
704 ALTER TABLE t4 CHANGE c1 c1 TINYINT UNSIGNED NULL;
708 SHOW CREATE TABLE t4;
710 t4 CREATE TABLE `t4` (
711 `c1` tinyint(3) unsigned DEFAULT NULL
712 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
716 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NULL);
720 SHOW CREATE TABLE t4;
722 t4 CREATE TABLE `t4` (
723 `c1` smallint(5) unsigned zerofill DEFAULT NULL
724 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
725 ALTER TABLE t4 CHANGE c1 c1 SMALLINT UNSIGNED NULL;
729 SHOW CREATE TABLE t4;
731 t4 CREATE TABLE `t4` (
732 `c1` smallint(5) unsigned DEFAULT NULL
733 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
737 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NULL);
741 SHOW CREATE TABLE t4;
743 t4 CREATE TABLE `t4` (
744 `c1` mediumint(8) unsigned zerofill DEFAULT NULL
745 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
746 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT UNSIGNED NULL;
750 SHOW CREATE TABLE t4;
752 t4 CREATE TABLE `t4` (
753 `c1` mediumint(8) unsigned DEFAULT NULL
754 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
758 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NULL);
762 SHOW CREATE TABLE t4;
764 t4 CREATE TABLE `t4` (
765 `c1` int(10) unsigned zerofill DEFAULT NULL
766 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
767 ALTER TABLE t4 CHANGE c1 c1 INT UNSIGNED NULL;
771 SHOW CREATE TABLE t4;
773 t4 CREATE TABLE `t4` (
774 `c1` int(10) unsigned DEFAULT NULL
775 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
779 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NULL);
783 SHOW CREATE TABLE t4;
785 t4 CREATE TABLE `t4` (
786 `c1` int(10) unsigned zerofill DEFAULT NULL
787 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
788 ALTER TABLE t4 CHANGE c1 c1 INTEGER UNSIGNED NULL;
792 SHOW CREATE TABLE t4;
794 t4 CREATE TABLE `t4` (
795 `c1` int(10) unsigned DEFAULT NULL
796 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
800 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NULL);
804 SHOW CREATE TABLE t4;
806 t4 CREATE TABLE `t4` (
807 `c1` bigint(20) unsigned zerofill DEFAULT NULL
808 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
809 ALTER TABLE t4 CHANGE c1 c1 BIGINT UNSIGNED NULL;
813 SHOW CREATE TABLE t4;
815 t4 CREATE TABLE `t4` (
816 `c1` bigint(20) unsigned DEFAULT NULL
817 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
821 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NULL);
825 SHOW CREATE TABLE t4;
827 t4 CREATE TABLE `t4` (
828 `c1` double unsigned zerofill DEFAULT NULL
829 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
830 ALTER TABLE t4 CHANGE c1 c1 REAL UNSIGNED NULL;
834 SHOW CREATE TABLE t4;
836 t4 CREATE TABLE `t4` (
837 `c1` double unsigned DEFAULT NULL
838 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
842 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NULL);
846 SHOW CREATE TABLE t4;
848 t4 CREATE TABLE `t4` (
849 `c1` double unsigned zerofill DEFAULT NULL
850 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
851 ALTER TABLE t4 CHANGE c1 c1 DOUBLE UNSIGNED NULL;
855 SHOW CREATE TABLE t4;
857 t4 CREATE TABLE `t4` (
858 `c1` double unsigned DEFAULT NULL
859 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
863 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NULL);
867 SHOW CREATE TABLE t4;
869 t4 CREATE TABLE `t4` (
870 `c1` float unsigned zerofill DEFAULT NULL
871 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
872 ALTER TABLE t4 CHANGE c1 c1 FLOAT UNSIGNED NULL;
876 SHOW CREATE TABLE t4;
878 t4 CREATE TABLE `t4` (
879 `c1` float unsigned DEFAULT NULL
880 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
884 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NULL);
888 SHOW CREATE TABLE t4;
890 t4 CREATE TABLE `t4` (
891 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
892 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
893 ALTER TABLE t4 CHANGE c1 c1 DECIMAL UNSIGNED NULL;
897 SHOW CREATE TABLE t4;
899 t4 CREATE TABLE `t4` (
900 `c1` decimal(10,0) unsigned DEFAULT NULL
901 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
905 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NULL);
909 SHOW CREATE TABLE t4;
911 t4 CREATE TABLE `t4` (
912 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
913 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
914 ALTER TABLE t4 CHANGE c1 c1 NUMERIC UNSIGNED NULL;
918 SHOW CREATE TABLE t4;
920 t4 CREATE TABLE `t4` (
921 `c1` decimal(10,0) unsigned DEFAULT NULL
922 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
926 CREATE TABLE t4(c1 TINYINT ZEROFILL NOT NULL);
930 SHOW CREATE TABLE t4;
932 t4 CREATE TABLE `t4` (
933 `c1` tinyint(3) unsigned zerofill NOT NULL
934 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
935 ALTER TABLE t4 MODIFY c1 TINYINT NOT NULL;
939 SHOW CREATE TABLE t4;
941 t4 CREATE TABLE `t4` (
942 `c1` tinyint(4) NOT NULL
943 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
947 CREATE TABLE t4(c1 SMALLINT ZEROFILL NOT NULL);
951 SHOW CREATE TABLE t4;
953 t4 CREATE TABLE `t4` (
954 `c1` smallint(5) unsigned zerofill NOT NULL
955 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
956 ALTER TABLE t4 MODIFY c1 SMALLINT NOT NULL;
960 SHOW CREATE TABLE t4;
962 t4 CREATE TABLE `t4` (
963 `c1` smallint(6) NOT NULL
964 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
968 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NOT NULL);
972 SHOW CREATE TABLE t4;
974 t4 CREATE TABLE `t4` (
975 `c1` mediumint(8) unsigned zerofill NOT NULL
976 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
977 ALTER TABLE t4 MODIFY c1 MEDIUMINT NOT NULL;
981 SHOW CREATE TABLE t4;
983 t4 CREATE TABLE `t4` (
984 `c1` mediumint(9) NOT NULL
985 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
989 CREATE TABLE t4(c1 INT ZEROFILL NOT NULL);
993 SHOW CREATE TABLE t4;
995 t4 CREATE TABLE `t4` (
996 `c1` int(10) unsigned zerofill NOT NULL
997 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
998 ALTER TABLE t4 MODIFY c1 INT NOT NULL;
1002 SHOW CREATE TABLE t4;
1004 t4 CREATE TABLE `t4` (
1005 `c1` int(11) NOT NULL
1006 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1010 CREATE TABLE t4(c1 INTEGER ZEROFILL NOT NULL);
1014 SHOW CREATE TABLE t4;
1016 t4 CREATE TABLE `t4` (
1017 `c1` int(10) unsigned zerofill NOT NULL
1018 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1019 ALTER TABLE t4 MODIFY c1 INTEGER NOT NULL;
1023 SHOW CREATE TABLE t4;
1025 t4 CREATE TABLE `t4` (
1026 `c1` int(11) NOT NULL
1027 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1031 CREATE TABLE t4(c1 BIGINT ZEROFILL NOT NULL);
1035 SHOW CREATE TABLE t4;
1037 t4 CREATE TABLE `t4` (
1038 `c1` bigint(20) unsigned zerofill NOT NULL
1039 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1040 ALTER TABLE t4 MODIFY c1 BIGINT NOT NULL;
1044 SHOW CREATE TABLE t4;
1046 t4 CREATE TABLE `t4` (
1047 `c1` bigint(20) NOT NULL
1048 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1052 CREATE TABLE t4(c1 REAL ZEROFILL NOT NULL);
1056 SHOW CREATE TABLE t4;
1058 t4 CREATE TABLE `t4` (
1059 `c1` double unsigned zerofill NOT NULL
1060 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1061 ALTER TABLE t4 MODIFY c1 REAL NOT NULL;
1065 SHOW CREATE TABLE t4;
1067 t4 CREATE TABLE `t4` (
1068 `c1` double NOT NULL
1069 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1073 CREATE TABLE t4(c1 DOUBLE ZEROFILL NOT NULL);
1077 SHOW CREATE TABLE t4;
1079 t4 CREATE TABLE `t4` (
1080 `c1` double unsigned zerofill NOT NULL
1081 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1082 ALTER TABLE t4 MODIFY c1 DOUBLE NOT NULL;
1086 SHOW CREATE TABLE t4;
1088 t4 CREATE TABLE `t4` (
1089 `c1` double NOT NULL
1090 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1094 CREATE TABLE t4(c1 FLOAT ZEROFILL NOT NULL);
1098 SHOW CREATE TABLE t4;
1100 t4 CREATE TABLE `t4` (
1101 `c1` float unsigned zerofill NOT NULL
1102 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1103 ALTER TABLE t4 MODIFY c1 FLOAT NOT NULL;
1107 SHOW CREATE TABLE t4;
1109 t4 CREATE TABLE `t4` (
1111 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1115 CREATE TABLE t4(c1 DECIMAL ZEROFILL NOT NULL);
1119 SHOW CREATE TABLE t4;
1121 t4 CREATE TABLE `t4` (
1122 `c1` decimal(10,0) unsigned zerofill NOT NULL
1123 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1124 ALTER TABLE t4 MODIFY c1 DECIMAL NOT NULL;
1128 SHOW CREATE TABLE t4;
1130 t4 CREATE TABLE `t4` (
1131 `c1` decimal(10,0) NOT NULL
1132 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1136 CREATE TABLE t4(c1 NUMERIC ZEROFILL NOT NULL);
1140 SHOW CREATE TABLE t4;
1142 t4 CREATE TABLE `t4` (
1143 `c1` decimal(10,0) unsigned zerofill NOT NULL
1144 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1145 ALTER TABLE t4 MODIFY c1 NUMERIC NOT NULL;
1149 SHOW CREATE TABLE t4;
1151 t4 CREATE TABLE `t4` (
1152 `c1` decimal(10,0) NOT NULL
1153 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1157 CREATE TABLE t4(c1 TINYINT ZEROFILL NOT NULL);
1161 SHOW CREATE TABLE t4;
1163 t4 CREATE TABLE `t4` (
1164 `c1` tinyint(3) unsigned zerofill NOT NULL
1165 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1166 ALTER TABLE t4 CHANGE c1 c1 TINYINT NOT NULL;
1170 SHOW CREATE TABLE t4;
1172 t4 CREATE TABLE `t4` (
1173 `c1` tinyint(4) NOT NULL
1174 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1178 CREATE TABLE t4(c1 SMALLINT ZEROFILL NOT NULL);
1182 SHOW CREATE TABLE t4;
1184 t4 CREATE TABLE `t4` (
1185 `c1` smallint(5) unsigned zerofill NOT NULL
1186 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1187 ALTER TABLE t4 CHANGE c1 c1 SMALLINT NOT NULL;
1191 SHOW CREATE TABLE t4;
1193 t4 CREATE TABLE `t4` (
1194 `c1` smallint(6) NOT NULL
1195 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1199 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NOT NULL);
1203 SHOW CREATE TABLE t4;
1205 t4 CREATE TABLE `t4` (
1206 `c1` mediumint(8) unsigned zerofill NOT NULL
1207 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1208 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT NOT NULL;
1212 SHOW CREATE TABLE t4;
1214 t4 CREATE TABLE `t4` (
1215 `c1` mediumint(9) NOT NULL
1216 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1220 CREATE TABLE t4(c1 INT ZEROFILL NOT NULL);
1224 SHOW CREATE TABLE t4;
1226 t4 CREATE TABLE `t4` (
1227 `c1` int(10) unsigned zerofill NOT NULL
1228 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1229 ALTER TABLE t4 CHANGE c1 c1 INT NOT NULL;
1233 SHOW CREATE TABLE t4;
1235 t4 CREATE TABLE `t4` (
1236 `c1` int(11) NOT NULL
1237 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1241 CREATE TABLE t4(c1 INTEGER ZEROFILL NOT NULL);
1245 SHOW CREATE TABLE t4;
1247 t4 CREATE TABLE `t4` (
1248 `c1` int(10) unsigned zerofill NOT NULL
1249 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1250 ALTER TABLE t4 CHANGE c1 c1 INTEGER NOT NULL;
1254 SHOW CREATE TABLE t4;
1256 t4 CREATE TABLE `t4` (
1257 `c1` int(11) NOT NULL
1258 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1262 CREATE TABLE t4(c1 BIGINT ZEROFILL NOT NULL);
1266 SHOW CREATE TABLE t4;
1268 t4 CREATE TABLE `t4` (
1269 `c1` bigint(20) unsigned zerofill NOT NULL
1270 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1271 ALTER TABLE t4 CHANGE c1 c1 BIGINT NOT NULL;
1275 SHOW CREATE TABLE t4;
1277 t4 CREATE TABLE `t4` (
1278 `c1` bigint(20) NOT NULL
1279 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1283 CREATE TABLE t4(c1 REAL ZEROFILL NOT NULL);
1287 SHOW CREATE TABLE t4;
1289 t4 CREATE TABLE `t4` (
1290 `c1` double unsigned zerofill NOT NULL
1291 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1292 ALTER TABLE t4 CHANGE c1 c1 REAL NOT NULL;
1296 SHOW CREATE TABLE t4;
1298 t4 CREATE TABLE `t4` (
1299 `c1` double NOT NULL
1300 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1304 CREATE TABLE t4(c1 DOUBLE ZEROFILL NOT NULL);
1308 SHOW CREATE TABLE t4;
1310 t4 CREATE TABLE `t4` (
1311 `c1` double unsigned zerofill NOT NULL
1312 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1313 ALTER TABLE t4 CHANGE c1 c1 DOUBLE NOT NULL;
1317 SHOW CREATE TABLE t4;
1319 t4 CREATE TABLE `t4` (
1320 `c1` double NOT NULL
1321 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1325 CREATE TABLE t4(c1 FLOAT ZEROFILL NOT NULL);
1329 SHOW CREATE TABLE t4;
1331 t4 CREATE TABLE `t4` (
1332 `c1` float unsigned zerofill NOT NULL
1333 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1334 ALTER TABLE t4 CHANGE c1 c1 FLOAT NOT NULL;
1338 SHOW CREATE TABLE t4;
1340 t4 CREATE TABLE `t4` (
1342 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1346 CREATE TABLE t4(c1 DECIMAL ZEROFILL NOT NULL);
1350 SHOW CREATE TABLE t4;
1352 t4 CREATE TABLE `t4` (
1353 `c1` decimal(10,0) unsigned zerofill NOT NULL
1354 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1355 ALTER TABLE t4 CHANGE c1 c1 DECIMAL NOT NULL;
1359 SHOW CREATE TABLE t4;
1361 t4 CREATE TABLE `t4` (
1362 `c1` decimal(10,0) NOT NULL
1363 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1367 CREATE TABLE t4(c1 NUMERIC ZEROFILL NOT NULL);
1371 SHOW CREATE TABLE t4;
1373 t4 CREATE TABLE `t4` (
1374 `c1` decimal(10,0) unsigned zerofill NOT NULL
1375 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1376 ALTER TABLE t4 CHANGE c1 c1 NUMERIC NOT NULL;
1380 SHOW CREATE TABLE t4;
1382 t4 CREATE TABLE `t4` (
1383 `c1` decimal(10,0) NOT NULL
1384 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1388 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NOT NULL);
1392 SHOW CREATE TABLE t4;
1394 t4 CREATE TABLE `t4` (
1395 `c1` tinyint(3) unsigned zerofill NOT NULL
1396 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1397 ALTER TABLE t4 MODIFY c1 TINYINT UNSIGNED NOT NULL;
1401 SHOW CREATE TABLE t4;
1403 t4 CREATE TABLE `t4` (
1404 `c1` tinyint(3) unsigned NOT NULL
1405 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1409 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NOT NULL);
1413 SHOW CREATE TABLE t4;
1415 t4 CREATE TABLE `t4` (
1416 `c1` smallint(5) unsigned zerofill NOT NULL
1417 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1418 ALTER TABLE t4 MODIFY c1 SMALLINT UNSIGNED NOT NULL;
1422 SHOW CREATE TABLE t4;
1424 t4 CREATE TABLE `t4` (
1425 `c1` smallint(5) unsigned NOT NULL
1426 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1430 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL);
1434 SHOW CREATE TABLE t4;
1436 t4 CREATE TABLE `t4` (
1437 `c1` mediumint(8) unsigned zerofill NOT NULL
1438 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1439 ALTER TABLE t4 MODIFY c1 MEDIUMINT UNSIGNED NOT NULL;
1443 SHOW CREATE TABLE t4;
1445 t4 CREATE TABLE `t4` (
1446 `c1` mediumint(8) unsigned NOT NULL
1447 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1451 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NOT NULL);
1455 SHOW CREATE TABLE t4;
1457 t4 CREATE TABLE `t4` (
1458 `c1` int(10) unsigned zerofill NOT NULL
1459 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1460 ALTER TABLE t4 MODIFY c1 INT UNSIGNED NOT NULL;
1464 SHOW CREATE TABLE t4;
1466 t4 CREATE TABLE `t4` (
1467 `c1` int(10) unsigned NOT NULL
1468 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1472 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NOT NULL);
1476 SHOW CREATE TABLE t4;
1478 t4 CREATE TABLE `t4` (
1479 `c1` int(10) unsigned zerofill NOT NULL
1480 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1481 ALTER TABLE t4 MODIFY c1 INTEGER UNSIGNED NOT NULL;
1485 SHOW CREATE TABLE t4;
1487 t4 CREATE TABLE `t4` (
1488 `c1` int(10) unsigned NOT NULL
1489 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1493 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NOT NULL);
1497 SHOW CREATE TABLE t4;
1499 t4 CREATE TABLE `t4` (
1500 `c1` bigint(20) unsigned zerofill NOT NULL
1501 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1502 ALTER TABLE t4 MODIFY c1 BIGINT UNSIGNED NOT NULL;
1506 SHOW CREATE TABLE t4;
1508 t4 CREATE TABLE `t4` (
1509 `c1` bigint(20) unsigned NOT NULL
1510 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1514 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NOT NULL);
1518 SHOW CREATE TABLE t4;
1520 t4 CREATE TABLE `t4` (
1521 `c1` double unsigned zerofill NOT NULL
1522 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1523 ALTER TABLE t4 MODIFY c1 REAL UNSIGNED NOT NULL;
1527 SHOW CREATE TABLE t4;
1529 t4 CREATE TABLE `t4` (
1530 `c1` double unsigned NOT NULL
1531 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1535 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NOT NULL);
1539 SHOW CREATE TABLE t4;
1541 t4 CREATE TABLE `t4` (
1542 `c1` double unsigned zerofill NOT NULL
1543 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1544 ALTER TABLE t4 MODIFY c1 DOUBLE UNSIGNED NOT NULL;
1548 SHOW CREATE TABLE t4;
1550 t4 CREATE TABLE `t4` (
1551 `c1` double unsigned NOT NULL
1552 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1556 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NOT NULL);
1560 SHOW CREATE TABLE t4;
1562 t4 CREATE TABLE `t4` (
1563 `c1` float unsigned zerofill NOT NULL
1564 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1565 ALTER TABLE t4 MODIFY c1 FLOAT UNSIGNED NOT NULL;
1569 SHOW CREATE TABLE t4;
1571 t4 CREATE TABLE `t4` (
1572 `c1` float unsigned NOT NULL
1573 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1577 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NOT NULL);
1581 SHOW CREATE TABLE t4;
1583 t4 CREATE TABLE `t4` (
1584 `c1` decimal(10,0) unsigned zerofill NOT NULL
1585 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1586 ALTER TABLE t4 MODIFY c1 DECIMAL UNSIGNED NOT NULL;
1590 SHOW CREATE TABLE t4;
1592 t4 CREATE TABLE `t4` (
1593 `c1` decimal(10,0) unsigned NOT NULL
1594 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1598 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NOT NULL);
1602 SHOW CREATE TABLE t4;
1604 t4 CREATE TABLE `t4` (
1605 `c1` decimal(10,0) unsigned zerofill NOT NULL
1606 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1607 ALTER TABLE t4 MODIFY c1 NUMERIC UNSIGNED NOT NULL;
1611 SHOW CREATE TABLE t4;
1613 t4 CREATE TABLE `t4` (
1614 `c1` decimal(10,0) unsigned NOT NULL
1615 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1619 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NOT NULL);
1623 SHOW CREATE TABLE t4;
1625 t4 CREATE TABLE `t4` (
1626 `c1` tinyint(3) unsigned zerofill NOT NULL
1627 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1628 ALTER TABLE t4 CHANGE c1 c1 TINYINT UNSIGNED NOT NULL;
1632 SHOW CREATE TABLE t4;
1634 t4 CREATE TABLE `t4` (
1635 `c1` tinyint(3) unsigned NOT NULL
1636 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1640 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NOT NULL);
1644 SHOW CREATE TABLE t4;
1646 t4 CREATE TABLE `t4` (
1647 `c1` smallint(5) unsigned zerofill NOT NULL
1648 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1649 ALTER TABLE t4 CHANGE c1 c1 SMALLINT UNSIGNED NOT NULL;
1653 SHOW CREATE TABLE t4;
1655 t4 CREATE TABLE `t4` (
1656 `c1` smallint(5) unsigned NOT NULL
1657 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1661 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL);
1665 SHOW CREATE TABLE t4;
1667 t4 CREATE TABLE `t4` (
1668 `c1` mediumint(8) unsigned zerofill NOT NULL
1669 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1670 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT UNSIGNED NOT NULL;
1674 SHOW CREATE TABLE t4;
1676 t4 CREATE TABLE `t4` (
1677 `c1` mediumint(8) unsigned NOT NULL
1678 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1682 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NOT NULL);
1686 SHOW CREATE TABLE t4;
1688 t4 CREATE TABLE `t4` (
1689 `c1` int(10) unsigned zerofill NOT NULL
1690 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1691 ALTER TABLE t4 CHANGE c1 c1 INT UNSIGNED NOT NULL;
1695 SHOW CREATE TABLE t4;
1697 t4 CREATE TABLE `t4` (
1698 `c1` int(10) unsigned NOT NULL
1699 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1703 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NOT NULL);
1707 SHOW CREATE TABLE t4;
1709 t4 CREATE TABLE `t4` (
1710 `c1` int(10) unsigned zerofill NOT NULL
1711 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1712 ALTER TABLE t4 CHANGE c1 c1 INTEGER UNSIGNED NOT NULL;
1716 SHOW CREATE TABLE t4;
1718 t4 CREATE TABLE `t4` (
1719 `c1` int(10) unsigned NOT NULL
1720 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1724 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NOT NULL);
1728 SHOW CREATE TABLE t4;
1730 t4 CREATE TABLE `t4` (
1731 `c1` bigint(20) unsigned zerofill NOT NULL
1732 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1733 ALTER TABLE t4 CHANGE c1 c1 BIGINT UNSIGNED NOT NULL;
1737 SHOW CREATE TABLE t4;
1739 t4 CREATE TABLE `t4` (
1740 `c1` bigint(20) unsigned NOT NULL
1741 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1745 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NOT NULL);
1749 SHOW CREATE TABLE t4;
1751 t4 CREATE TABLE `t4` (
1752 `c1` double unsigned zerofill NOT NULL
1753 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1754 ALTER TABLE t4 CHANGE c1 c1 REAL UNSIGNED NOT NULL;
1758 SHOW CREATE TABLE t4;
1760 t4 CREATE TABLE `t4` (
1761 `c1` double unsigned NOT NULL
1762 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1766 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NOT NULL);
1770 SHOW CREATE TABLE t4;
1772 t4 CREATE TABLE `t4` (
1773 `c1` double unsigned zerofill NOT NULL
1774 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1775 ALTER TABLE t4 CHANGE c1 c1 DOUBLE UNSIGNED NOT NULL;
1779 SHOW CREATE TABLE t4;
1781 t4 CREATE TABLE `t4` (
1782 `c1` double unsigned NOT NULL
1783 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1787 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NOT NULL);
1791 SHOW CREATE TABLE t4;
1793 t4 CREATE TABLE `t4` (
1794 `c1` float unsigned zerofill NOT NULL
1795 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1796 ALTER TABLE t4 CHANGE c1 c1 FLOAT UNSIGNED NOT NULL;
1800 SHOW CREATE TABLE t4;
1802 t4 CREATE TABLE `t4` (
1803 `c1` float unsigned NOT NULL
1804 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1808 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NOT NULL);
1812 SHOW CREATE TABLE t4;
1814 t4 CREATE TABLE `t4` (
1815 `c1` decimal(10,0) unsigned zerofill NOT NULL
1816 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1817 ALTER TABLE t4 CHANGE c1 c1 DECIMAL UNSIGNED NOT NULL;
1821 SHOW CREATE TABLE t4;
1823 t4 CREATE TABLE `t4` (
1824 `c1` decimal(10,0) unsigned NOT NULL
1825 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1829 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NOT NULL);
1833 SHOW CREATE TABLE t4;
1835 t4 CREATE TABLE `t4` (
1836 `c1` decimal(10,0) unsigned zerofill NOT NULL
1837 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1838 ALTER TABLE t4 CHANGE c1 c1 NUMERIC UNSIGNED NOT NULL;
1842 SHOW CREATE TABLE t4;
1844 t4 CREATE TABLE `t4` (
1845 `c1` decimal(10,0) unsigned NOT NULL
1846 ) ENGINE=ENGINE DEFAULT CHARSET=latin1