1
DROP TABLE IF EXISTS t3;
2
CREATE TABLE t3(c1 TINYINT NULL);
9
`c1` tinyint(4) DEFAULT NULL
10
) ENGINE=ENGINE DEFAULT CHARSET=latin1
11
ALTER TABLE t3 MODIFY c1 TINYINT UNSIGNED NULL;
17
t3 CREATE TABLE `t3` (
18
`c1` tinyint(3) unsigned DEFAULT NULL
19
) ENGINE=ENGINE DEFAULT CHARSET=latin1
23
CREATE TABLE t3(c1 SMALLINT NULL);
29
t3 CREATE TABLE `t3` (
30
`c1` smallint(6) DEFAULT NULL
31
) ENGINE=ENGINE DEFAULT CHARSET=latin1
32
ALTER TABLE t3 MODIFY c1 SMALLINT UNSIGNED NULL;
38
t3 CREATE TABLE `t3` (
39
`c1` smallint(5) unsigned DEFAULT NULL
40
) ENGINE=ENGINE DEFAULT CHARSET=latin1
44
CREATE TABLE t3(c1 MEDIUMINT NULL);
50
t3 CREATE TABLE `t3` (
51
`c1` mediumint(9) DEFAULT NULL
52
) ENGINE=ENGINE DEFAULT CHARSET=latin1
53
ALTER TABLE t3 MODIFY c1 MEDIUMINT UNSIGNED NULL;
59
t3 CREATE TABLE `t3` (
60
`c1` mediumint(8) unsigned DEFAULT NULL
61
) ENGINE=ENGINE DEFAULT CHARSET=latin1
65
CREATE TABLE t3(c1 INT NULL);
71
t3 CREATE TABLE `t3` (
72
`c1` int(11) DEFAULT NULL
73
) ENGINE=ENGINE DEFAULT CHARSET=latin1
74
ALTER TABLE t3 MODIFY c1 INT UNSIGNED NULL;
80
t3 CREATE TABLE `t3` (
81
`c1` int(10) unsigned DEFAULT NULL
82
) ENGINE=ENGINE DEFAULT CHARSET=latin1
86
CREATE TABLE t3(c1 INTEGER NULL);
92
t3 CREATE TABLE `t3` (
93
`c1` int(11) DEFAULT NULL
94
) ENGINE=ENGINE DEFAULT CHARSET=latin1
95
ALTER TABLE t3 MODIFY c1 INTEGER UNSIGNED NULL;
101
t3 CREATE TABLE `t3` (
102
`c1` int(10) unsigned DEFAULT NULL
103
) ENGINE=ENGINE DEFAULT CHARSET=latin1
107
CREATE TABLE t3(c1 BIGINT NULL);
111
SHOW CREATE TABLE t3;
113
t3 CREATE TABLE `t3` (
114
`c1` bigint(20) DEFAULT NULL
115
) ENGINE=ENGINE DEFAULT CHARSET=latin1
116
ALTER TABLE t3 MODIFY c1 BIGINT UNSIGNED NULL;
120
SHOW CREATE TABLE t3;
122
t3 CREATE TABLE `t3` (
123
`c1` bigint(20) unsigned DEFAULT NULL
124
) ENGINE=ENGINE DEFAULT CHARSET=latin1
128
CREATE TABLE t3(c1 REAL NULL);
132
SHOW CREATE TABLE t3;
134
t3 CREATE TABLE `t3` (
135
`c1` double DEFAULT NULL
136
) ENGINE=ENGINE DEFAULT CHARSET=latin1
137
ALTER TABLE t3 MODIFY c1 REAL UNSIGNED NULL;
141
SHOW CREATE TABLE t3;
143
t3 CREATE TABLE `t3` (
144
`c1` double unsigned DEFAULT NULL
145
) ENGINE=ENGINE DEFAULT CHARSET=latin1
149
CREATE TABLE t3(c1 DOUBLE NULL);
153
SHOW CREATE TABLE t3;
155
t3 CREATE TABLE `t3` (
156
`c1` double DEFAULT NULL
157
) ENGINE=ENGINE DEFAULT CHARSET=latin1
158
ALTER TABLE t3 MODIFY c1 DOUBLE UNSIGNED NULL;
162
SHOW CREATE TABLE t3;
164
t3 CREATE TABLE `t3` (
165
`c1` double unsigned DEFAULT NULL
166
) ENGINE=ENGINE DEFAULT CHARSET=latin1
170
CREATE TABLE t3(c1 FLOAT NULL);
174
SHOW CREATE TABLE t3;
176
t3 CREATE TABLE `t3` (
177
`c1` float DEFAULT NULL
178
) ENGINE=ENGINE DEFAULT CHARSET=latin1
179
ALTER TABLE t3 MODIFY c1 FLOAT UNSIGNED NULL;
183
SHOW CREATE TABLE t3;
185
t3 CREATE TABLE `t3` (
186
`c1` float unsigned DEFAULT NULL
187
) ENGINE=ENGINE DEFAULT CHARSET=latin1
191
CREATE TABLE t3(c1 DECIMAL NULL);
195
SHOW CREATE TABLE t3;
197
t3 CREATE TABLE `t3` (
198
`c1` decimal(10,0) DEFAULT NULL
199
) ENGINE=ENGINE DEFAULT CHARSET=latin1
200
ALTER TABLE t3 MODIFY c1 DECIMAL UNSIGNED NULL;
204
SHOW CREATE TABLE t3;
206
t3 CREATE TABLE `t3` (
207
`c1` decimal(10,0) unsigned DEFAULT NULL
208
) ENGINE=ENGINE DEFAULT CHARSET=latin1
212
CREATE TABLE t3(c1 NUMERIC NULL);
216
SHOW CREATE TABLE t3;
218
t3 CREATE TABLE `t3` (
219
`c1` decimal(10,0) DEFAULT NULL
220
) ENGINE=ENGINE DEFAULT CHARSET=latin1
221
ALTER TABLE t3 MODIFY c1 NUMERIC UNSIGNED NULL;
225
SHOW CREATE TABLE t3;
227
t3 CREATE TABLE `t3` (
228
`c1` decimal(10,0) unsigned DEFAULT NULL
229
) ENGINE=ENGINE DEFAULT CHARSET=latin1
233
CREATE TABLE t3(c1 TINYINT NULL);
237
SHOW CREATE TABLE t3;
239
t3 CREATE TABLE `t3` (
240
`c1` tinyint(4) DEFAULT NULL
241
) ENGINE=ENGINE DEFAULT CHARSET=latin1
242
ALTER TABLE t3 CHANGE c1 c1 TINYINT UNSIGNED NULL;
246
SHOW CREATE TABLE t3;
248
t3 CREATE TABLE `t3` (
249
`c1` tinyint(3) unsigned DEFAULT NULL
250
) ENGINE=ENGINE DEFAULT CHARSET=latin1
254
CREATE TABLE t3(c1 SMALLINT NULL);
258
SHOW CREATE TABLE t3;
260
t3 CREATE TABLE `t3` (
261
`c1` smallint(6) DEFAULT NULL
262
) ENGINE=ENGINE DEFAULT CHARSET=latin1
263
ALTER TABLE t3 CHANGE c1 c1 SMALLINT UNSIGNED NULL;
267
SHOW CREATE TABLE t3;
269
t3 CREATE TABLE `t3` (
270
`c1` smallint(5) unsigned DEFAULT NULL
271
) ENGINE=ENGINE DEFAULT CHARSET=latin1
275
CREATE TABLE t3(c1 MEDIUMINT NULL);
279
SHOW CREATE TABLE t3;
281
t3 CREATE TABLE `t3` (
282
`c1` mediumint(9) DEFAULT NULL
283
) ENGINE=ENGINE DEFAULT CHARSET=latin1
284
ALTER TABLE t3 CHANGE c1 c1 MEDIUMINT UNSIGNED NULL;
288
SHOW CREATE TABLE t3;
290
t3 CREATE TABLE `t3` (
291
`c1` mediumint(8) unsigned DEFAULT NULL
292
) ENGINE=ENGINE DEFAULT CHARSET=latin1
296
CREATE TABLE t3(c1 INT NULL);
300
SHOW CREATE TABLE t3;
302
t3 CREATE TABLE `t3` (
303
`c1` int(11) DEFAULT NULL
304
) ENGINE=ENGINE DEFAULT CHARSET=latin1
305
ALTER TABLE t3 CHANGE c1 c1 INT UNSIGNED NULL;
309
SHOW CREATE TABLE t3;
311
t3 CREATE TABLE `t3` (
312
`c1` int(10) unsigned DEFAULT NULL
313
) ENGINE=ENGINE DEFAULT CHARSET=latin1
317
CREATE TABLE t3(c1 INTEGER NULL);
321
SHOW CREATE TABLE t3;
323
t3 CREATE TABLE `t3` (
324
`c1` int(11) DEFAULT NULL
325
) ENGINE=ENGINE DEFAULT CHARSET=latin1
326
ALTER TABLE t3 CHANGE c1 c1 INTEGER UNSIGNED NULL;
330
SHOW CREATE TABLE t3;
332
t3 CREATE TABLE `t3` (
333
`c1` int(10) unsigned DEFAULT NULL
334
) ENGINE=ENGINE DEFAULT CHARSET=latin1
338
CREATE TABLE t3(c1 BIGINT NULL);
342
SHOW CREATE TABLE t3;
344
t3 CREATE TABLE `t3` (
345
`c1` bigint(20) DEFAULT NULL
346
) ENGINE=ENGINE DEFAULT CHARSET=latin1
347
ALTER TABLE t3 CHANGE c1 c1 BIGINT UNSIGNED NULL;
351
SHOW CREATE TABLE t3;
353
t3 CREATE TABLE `t3` (
354
`c1` bigint(20) unsigned DEFAULT NULL
355
) ENGINE=ENGINE DEFAULT CHARSET=latin1
359
CREATE TABLE t3(c1 REAL NULL);
363
SHOW CREATE TABLE t3;
365
t3 CREATE TABLE `t3` (
366
`c1` double DEFAULT NULL
367
) ENGINE=ENGINE DEFAULT CHARSET=latin1
368
ALTER TABLE t3 CHANGE c1 c1 REAL UNSIGNED NULL;
372
SHOW CREATE TABLE t3;
374
t3 CREATE TABLE `t3` (
375
`c1` double unsigned DEFAULT NULL
376
) ENGINE=ENGINE DEFAULT CHARSET=latin1
380
CREATE TABLE t3(c1 DOUBLE NULL);
384
SHOW CREATE TABLE t3;
386
t3 CREATE TABLE `t3` (
387
`c1` double DEFAULT NULL
388
) ENGINE=ENGINE DEFAULT CHARSET=latin1
389
ALTER TABLE t3 CHANGE c1 c1 DOUBLE UNSIGNED NULL;
393
SHOW CREATE TABLE t3;
395
t3 CREATE TABLE `t3` (
396
`c1` double unsigned DEFAULT NULL
397
) ENGINE=ENGINE DEFAULT CHARSET=latin1
401
CREATE TABLE t3(c1 FLOAT NULL);
405
SHOW CREATE TABLE t3;
407
t3 CREATE TABLE `t3` (
408
`c1` float DEFAULT NULL
409
) ENGINE=ENGINE DEFAULT CHARSET=latin1
410
ALTER TABLE t3 CHANGE c1 c1 FLOAT UNSIGNED NULL;
414
SHOW CREATE TABLE t3;
416
t3 CREATE TABLE `t3` (
417
`c1` float unsigned DEFAULT NULL
418
) ENGINE=ENGINE DEFAULT CHARSET=latin1
422
CREATE TABLE t3(c1 DECIMAL NULL);
426
SHOW CREATE TABLE t3;
428
t3 CREATE TABLE `t3` (
429
`c1` decimal(10,0) DEFAULT NULL
430
) ENGINE=ENGINE DEFAULT CHARSET=latin1
431
ALTER TABLE t3 CHANGE c1 c1 DECIMAL UNSIGNED NULL;
435
SHOW CREATE TABLE t3;
437
t3 CREATE TABLE `t3` (
438
`c1` decimal(10,0) unsigned DEFAULT NULL
439
) ENGINE=ENGINE DEFAULT CHARSET=latin1
443
CREATE TABLE t3(c1 NUMERIC NULL);
447
SHOW CREATE TABLE t3;
449
t3 CREATE TABLE `t3` (
450
`c1` decimal(10,0) DEFAULT NULL
451
) ENGINE=ENGINE DEFAULT CHARSET=latin1
452
ALTER TABLE t3 CHANGE c1 c1 NUMERIC UNSIGNED NULL;
456
SHOW CREATE TABLE t3;
458
t3 CREATE TABLE `t3` (
459
`c1` decimal(10,0) unsigned DEFAULT NULL
460
) ENGINE=ENGINE DEFAULT CHARSET=latin1
464
CREATE TABLE t3(c1 TINYINT NOT NULL);
468
SHOW CREATE TABLE t3;
470
t3 CREATE TABLE `t3` (
471
`c1` tinyint(4) NOT NULL
472
) ENGINE=ENGINE DEFAULT CHARSET=latin1
473
ALTER TABLE t3 MODIFY c1 TINYINT UNSIGNED NOT NULL;
477
SHOW CREATE TABLE t3;
479
t3 CREATE TABLE `t3` (
480
`c1` tinyint(3) unsigned NOT NULL
481
) ENGINE=ENGINE DEFAULT CHARSET=latin1
485
CREATE TABLE t3(c1 SMALLINT NOT NULL);
489
SHOW CREATE TABLE t3;
491
t3 CREATE TABLE `t3` (
492
`c1` smallint(6) NOT NULL
493
) ENGINE=ENGINE DEFAULT CHARSET=latin1
494
ALTER TABLE t3 MODIFY c1 SMALLINT UNSIGNED NOT NULL;
498
SHOW CREATE TABLE t3;
500
t3 CREATE TABLE `t3` (
501
`c1` smallint(5) unsigned NOT NULL
502
) ENGINE=ENGINE DEFAULT CHARSET=latin1
506
CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
510
SHOW CREATE TABLE t3;
512
t3 CREATE TABLE `t3` (
513
`c1` mediumint(9) NOT NULL
514
) ENGINE=ENGINE DEFAULT CHARSET=latin1
515
ALTER TABLE t3 MODIFY c1 MEDIUMINT UNSIGNED NOT NULL;
519
SHOW CREATE TABLE t3;
521
t3 CREATE TABLE `t3` (
522
`c1` mediumint(8) unsigned NOT NULL
523
) ENGINE=ENGINE DEFAULT CHARSET=latin1
527
CREATE TABLE t3(c1 INT NOT NULL);
531
SHOW CREATE TABLE t3;
533
t3 CREATE TABLE `t3` (
534
`c1` int(11) NOT NULL
535
) ENGINE=ENGINE DEFAULT CHARSET=latin1
536
ALTER TABLE t3 MODIFY c1 INT UNSIGNED NOT NULL;
540
SHOW CREATE TABLE t3;
542
t3 CREATE TABLE `t3` (
543
`c1` int(10) unsigned NOT NULL
544
) ENGINE=ENGINE DEFAULT CHARSET=latin1
548
CREATE TABLE t3(c1 INTEGER NOT NULL);
552
SHOW CREATE TABLE t3;
554
t3 CREATE TABLE `t3` (
555
`c1` int(11) NOT NULL
556
) ENGINE=ENGINE DEFAULT CHARSET=latin1
557
ALTER TABLE t3 MODIFY c1 INTEGER UNSIGNED NOT NULL;
561
SHOW CREATE TABLE t3;
563
t3 CREATE TABLE `t3` (
564
`c1` int(10) unsigned NOT NULL
565
) ENGINE=ENGINE DEFAULT CHARSET=latin1
569
CREATE TABLE t3(c1 BIGINT NOT NULL);
573
SHOW CREATE TABLE t3;
575
t3 CREATE TABLE `t3` (
576
`c1` bigint(20) NOT NULL
577
) ENGINE=ENGINE DEFAULT CHARSET=latin1
578
ALTER TABLE t3 MODIFY c1 BIGINT UNSIGNED NOT NULL;
582
SHOW CREATE TABLE t3;
584
t3 CREATE TABLE `t3` (
585
`c1` bigint(20) unsigned NOT NULL
586
) ENGINE=ENGINE DEFAULT CHARSET=latin1
590
CREATE TABLE t3(c1 REAL NOT NULL);
594
SHOW CREATE TABLE t3;
596
t3 CREATE TABLE `t3` (
598
) ENGINE=ENGINE DEFAULT CHARSET=latin1
599
ALTER TABLE t3 MODIFY c1 REAL UNSIGNED NOT NULL;
603
SHOW CREATE TABLE t3;
605
t3 CREATE TABLE `t3` (
606
`c1` double unsigned NOT NULL
607
) ENGINE=ENGINE DEFAULT CHARSET=latin1
611
CREATE TABLE t3(c1 DOUBLE NOT NULL);
615
SHOW CREATE TABLE t3;
617
t3 CREATE TABLE `t3` (
619
) ENGINE=ENGINE DEFAULT CHARSET=latin1
620
ALTER TABLE t3 MODIFY c1 DOUBLE UNSIGNED NOT NULL;
624
SHOW CREATE TABLE t3;
626
t3 CREATE TABLE `t3` (
627
`c1` double unsigned NOT NULL
628
) ENGINE=ENGINE DEFAULT CHARSET=latin1
632
CREATE TABLE t3(c1 FLOAT NOT NULL);
636
SHOW CREATE TABLE t3;
638
t3 CREATE TABLE `t3` (
640
) ENGINE=ENGINE DEFAULT CHARSET=latin1
641
ALTER TABLE t3 MODIFY c1 FLOAT UNSIGNED NOT NULL;
645
SHOW CREATE TABLE t3;
647
t3 CREATE TABLE `t3` (
648
`c1` float unsigned NOT NULL
649
) ENGINE=ENGINE DEFAULT CHARSET=latin1
653
CREATE TABLE t3(c1 DECIMAL NOT NULL);
657
SHOW CREATE TABLE t3;
659
t3 CREATE TABLE `t3` (
660
`c1` decimal(10,0) NOT NULL
661
) ENGINE=ENGINE DEFAULT CHARSET=latin1
662
ALTER TABLE t3 MODIFY c1 DECIMAL UNSIGNED NOT NULL;
666
SHOW CREATE TABLE t3;
668
t3 CREATE TABLE `t3` (
669
`c1` decimal(10,0) unsigned NOT NULL
670
) ENGINE=ENGINE DEFAULT CHARSET=latin1
674
CREATE TABLE t3(c1 NUMERIC NOT NULL);
678
SHOW CREATE TABLE t3;
680
t3 CREATE TABLE `t3` (
681
`c1` decimal(10,0) NOT NULL
682
) ENGINE=ENGINE DEFAULT CHARSET=latin1
683
ALTER TABLE t3 MODIFY c1 NUMERIC UNSIGNED NOT NULL;
687
SHOW CREATE TABLE t3;
689
t3 CREATE TABLE `t3` (
690
`c1` decimal(10,0) unsigned NOT NULL
691
) ENGINE=ENGINE DEFAULT CHARSET=latin1
695
CREATE TABLE t3(c1 TINYINT NOT NULL);
699
SHOW CREATE TABLE t3;
701
t3 CREATE TABLE `t3` (
702
`c1` tinyint(4) NOT NULL
703
) ENGINE=ENGINE DEFAULT CHARSET=latin1
704
ALTER TABLE t3 CHANGE c1 c1 TINYINT UNSIGNED NOT NULL;
708
SHOW CREATE TABLE t3;
710
t3 CREATE TABLE `t3` (
711
`c1` tinyint(3) unsigned NOT NULL
712
) ENGINE=ENGINE DEFAULT CHARSET=latin1
716
CREATE TABLE t3(c1 SMALLINT NOT NULL);
720
SHOW CREATE TABLE t3;
722
t3 CREATE TABLE `t3` (
723
`c1` smallint(6) NOT NULL
724
) ENGINE=ENGINE DEFAULT CHARSET=latin1
725
ALTER TABLE t3 CHANGE c1 c1 SMALLINT UNSIGNED NOT NULL;
729
SHOW CREATE TABLE t3;
731
t3 CREATE TABLE `t3` (
732
`c1` smallint(5) unsigned NOT NULL
733
) ENGINE=ENGINE DEFAULT CHARSET=latin1
737
CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
741
SHOW CREATE TABLE t3;
743
t3 CREATE TABLE `t3` (
744
`c1` mediumint(9) NOT NULL
745
) ENGINE=ENGINE DEFAULT CHARSET=latin1
746
ALTER TABLE t3 CHANGE c1 c1 MEDIUMINT UNSIGNED NOT NULL;
750
SHOW CREATE TABLE t3;
752
t3 CREATE TABLE `t3` (
753
`c1` mediumint(8) unsigned NOT NULL
754
) ENGINE=ENGINE DEFAULT CHARSET=latin1
758
CREATE TABLE t3(c1 INT NOT NULL);
762
SHOW CREATE TABLE t3;
764
t3 CREATE TABLE `t3` (
765
`c1` int(11) NOT NULL
766
) ENGINE=ENGINE DEFAULT CHARSET=latin1
767
ALTER TABLE t3 CHANGE c1 c1 INT UNSIGNED NOT NULL;
771
SHOW CREATE TABLE t3;
773
t3 CREATE TABLE `t3` (
774
`c1` int(10) unsigned NOT NULL
775
) ENGINE=ENGINE DEFAULT CHARSET=latin1
779
CREATE TABLE t3(c1 INTEGER NOT NULL);
783
SHOW CREATE TABLE t3;
785
t3 CREATE TABLE `t3` (
786
`c1` int(11) NOT NULL
787
) ENGINE=ENGINE DEFAULT CHARSET=latin1
788
ALTER TABLE t3 CHANGE c1 c1 INTEGER UNSIGNED NOT NULL;
792
SHOW CREATE TABLE t3;
794
t3 CREATE TABLE `t3` (
795
`c1` int(10) unsigned NOT NULL
796
) ENGINE=ENGINE DEFAULT CHARSET=latin1
800
CREATE TABLE t3(c1 BIGINT NOT NULL);
804
SHOW CREATE TABLE t3;
806
t3 CREATE TABLE `t3` (
807
`c1` bigint(20) NOT NULL
808
) ENGINE=ENGINE DEFAULT CHARSET=latin1
809
ALTER TABLE t3 CHANGE c1 c1 BIGINT UNSIGNED NOT NULL;
813
SHOW CREATE TABLE t3;
815
t3 CREATE TABLE `t3` (
816
`c1` bigint(20) unsigned NOT NULL
817
) ENGINE=ENGINE DEFAULT CHARSET=latin1
821
CREATE TABLE t3(c1 REAL NOT NULL);
825
SHOW CREATE TABLE t3;
827
t3 CREATE TABLE `t3` (
829
) ENGINE=ENGINE DEFAULT CHARSET=latin1
830
ALTER TABLE t3 CHANGE c1 c1 REAL UNSIGNED NOT NULL;
834
SHOW CREATE TABLE t3;
836
t3 CREATE TABLE `t3` (
837
`c1` double unsigned NOT NULL
838
) ENGINE=ENGINE DEFAULT CHARSET=latin1
842
CREATE TABLE t3(c1 DOUBLE NOT NULL);
846
SHOW CREATE TABLE t3;
848
t3 CREATE TABLE `t3` (
850
) ENGINE=ENGINE DEFAULT CHARSET=latin1
851
ALTER TABLE t3 CHANGE c1 c1 DOUBLE UNSIGNED NOT NULL;
855
SHOW CREATE TABLE t3;
857
t3 CREATE TABLE `t3` (
858
`c1` double unsigned NOT NULL
859
) ENGINE=ENGINE DEFAULT CHARSET=latin1
863
CREATE TABLE t3(c1 FLOAT NOT NULL);
867
SHOW CREATE TABLE t3;
869
t3 CREATE TABLE `t3` (
871
) ENGINE=ENGINE DEFAULT CHARSET=latin1
872
ALTER TABLE t3 CHANGE c1 c1 FLOAT UNSIGNED NOT NULL;
876
SHOW CREATE TABLE t3;
878
t3 CREATE TABLE `t3` (
879
`c1` float unsigned NOT NULL
880
) ENGINE=ENGINE DEFAULT CHARSET=latin1
884
CREATE TABLE t3(c1 DECIMAL NOT NULL);
888
SHOW CREATE TABLE t3;
890
t3 CREATE TABLE `t3` (
891
`c1` decimal(10,0) NOT NULL
892
) ENGINE=ENGINE DEFAULT CHARSET=latin1
893
ALTER TABLE t3 CHANGE c1 c1 DECIMAL UNSIGNED NOT NULL;
897
SHOW CREATE TABLE t3;
899
t3 CREATE TABLE `t3` (
900
`c1` decimal(10,0) unsigned NOT NULL
901
) ENGINE=ENGINE DEFAULT CHARSET=latin1
905
CREATE TABLE t3(c1 NUMERIC NOT NULL);
909
SHOW CREATE TABLE t3;
911
t3 CREATE TABLE `t3` (
912
`c1` decimal(10,0) NOT NULL
913
) ENGINE=ENGINE DEFAULT CHARSET=latin1
914
ALTER TABLE t3 CHANGE c1 c1 NUMERIC UNSIGNED NOT NULL;
918
SHOW CREATE TABLE t3;
920
t3 CREATE TABLE `t3` (
921
`c1` decimal(10,0) unsigned NOT NULL
922
) ENGINE=ENGINE DEFAULT CHARSET=latin1