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