1
DROP TABLE IF EXISTS t5;
2
CREATE TABLE t5(c1 BIT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
10
`c2` int(11) NOT NULL,
11
`c3` char(10) DEFAULT NULL,
13
) ENGINE=ENGINE DEFAULT CHARSET=latin1
14
ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
20
t5 CREATE TABLE `t5` (
22
`c2` int(11) NOT NULL,
23
`c4` char(5) DEFAULT NULL,
24
`c3` char(10) DEFAULT NULL,
26
) ENGINE=ENGINE DEFAULT CHARSET=latin1
30
CREATE TABLE t5(c1 TINYINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
36
t5 CREATE TABLE `t5` (
37
`c1` tinyint(4) NOT NULL,
38
`c2` int(11) NOT NULL,
39
`c3` char(10) DEFAULT NULL,
41
) ENGINE=ENGINE DEFAULT CHARSET=latin1
42
ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
48
t5 CREATE TABLE `t5` (
49
`c1` tinyint(4) NOT NULL,
50
`c2` int(11) NOT NULL,
51
`c4` char(5) DEFAULT NULL,
52
`c3` char(10) DEFAULT NULL,
54
) ENGINE=ENGINE DEFAULT CHARSET=latin1
58
CREATE TABLE t5(c1 SMALLINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
64
t5 CREATE TABLE `t5` (
65
`c1` smallint(6) NOT NULL,
66
`c2` int(11) NOT NULL,
67
`c3` char(10) DEFAULT NULL,
69
) ENGINE=ENGINE DEFAULT CHARSET=latin1
70
ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
76
t5 CREATE TABLE `t5` (
77
`c1` smallint(6) NOT NULL,
78
`c2` int(11) NOT NULL,
79
`c4` char(5) DEFAULT NULL,
80
`c3` char(10) DEFAULT NULL,
82
) ENGINE=ENGINE DEFAULT CHARSET=latin1
86
CREATE TABLE t5(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
92
t5 CREATE TABLE `t5` (
93
`c1` mediumint(9) NOT NULL,
94
`c2` int(11) NOT NULL,
95
`c3` char(10) DEFAULT NULL,
97
) ENGINE=ENGINE DEFAULT CHARSET=latin1
98
ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
102
SHOW CREATE TABLE t5;
104
t5 CREATE TABLE `t5` (
105
`c1` mediumint(9) NOT NULL,
106
`c2` int(11) NOT NULL,
107
`c4` char(5) DEFAULT NULL,
108
`c3` char(10) DEFAULT NULL,
110
) ENGINE=ENGINE DEFAULT CHARSET=latin1
114
CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
118
SHOW CREATE TABLE t5;
120
t5 CREATE TABLE `t5` (
121
`c1` int(11) NOT NULL,
122
`c2` int(11) NOT NULL,
123
`c3` char(10) DEFAULT NULL,
125
) ENGINE=ENGINE DEFAULT CHARSET=latin1
126
ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
130
SHOW CREATE TABLE t5;
132
t5 CREATE TABLE `t5` (
133
`c1` int(11) NOT NULL,
134
`c2` int(11) NOT NULL,
135
`c4` char(5) DEFAULT NULL,
136
`c3` char(10) DEFAULT NULL,
138
) ENGINE=ENGINE DEFAULT CHARSET=latin1
142
CREATE TABLE t5(c1 INTEGER NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
146
SHOW CREATE TABLE t5;
148
t5 CREATE TABLE `t5` (
149
`c1` int(11) NOT NULL,
150
`c2` int(11) NOT NULL,
151
`c3` char(10) DEFAULT NULL,
153
) ENGINE=ENGINE DEFAULT CHARSET=latin1
154
ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
158
SHOW CREATE TABLE t5;
160
t5 CREATE TABLE `t5` (
161
`c1` int(11) NOT NULL,
162
`c2` int(11) NOT NULL,
163
`c4` char(5) DEFAULT NULL,
164
`c3` char(10) DEFAULT NULL,
166
) ENGINE=ENGINE DEFAULT CHARSET=latin1
170
CREATE TABLE t5(c1 BIGINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
174
SHOW CREATE TABLE t5;
176
t5 CREATE TABLE `t5` (
177
`c1` bigint(20) NOT NULL,
178
`c2` int(11) NOT NULL,
179
`c3` char(10) DEFAULT NULL,
181
) ENGINE=ENGINE DEFAULT CHARSET=latin1
182
ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
186
SHOW CREATE TABLE t5;
188
t5 CREATE TABLE `t5` (
189
`c1` bigint(20) NOT NULL,
190
`c2` int(11) NOT NULL,
191
`c4` char(5) DEFAULT NULL,
192
`c3` char(10) DEFAULT NULL,
194
) ENGINE=ENGINE DEFAULT CHARSET=latin1
198
CREATE TABLE t5(c1 REAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
202
SHOW CREATE TABLE t5;
204
t5 CREATE TABLE `t5` (
205
`c1` double NOT NULL,
206
`c2` int(11) NOT NULL,
207
`c3` char(10) DEFAULT NULL,
209
) ENGINE=ENGINE DEFAULT CHARSET=latin1
210
ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
214
SHOW CREATE TABLE t5;
216
t5 CREATE TABLE `t5` (
217
`c1` double NOT NULL,
218
`c2` int(11) NOT NULL,
219
`c4` char(5) DEFAULT NULL,
220
`c3` char(10) DEFAULT NULL,
222
) ENGINE=ENGINE DEFAULT CHARSET=latin1
226
CREATE TABLE t5(c1 DOUBLE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
230
SHOW CREATE TABLE t5;
232
t5 CREATE TABLE `t5` (
233
`c1` double NOT NULL,
234
`c2` int(11) NOT NULL,
235
`c3` char(10) DEFAULT NULL,
237
) ENGINE=ENGINE DEFAULT CHARSET=latin1
238
ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
242
SHOW CREATE TABLE t5;
244
t5 CREATE TABLE `t5` (
245
`c1` double NOT NULL,
246
`c2` int(11) NOT NULL,
247
`c4` char(5) DEFAULT NULL,
248
`c3` char(10) DEFAULT NULL,
250
) ENGINE=ENGINE DEFAULT CHARSET=latin1
254
CREATE TABLE t5(c1 FLOAT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
258
SHOW CREATE TABLE t5;
260
t5 CREATE TABLE `t5` (
262
`c2` int(11) NOT NULL,
263
`c3` char(10) DEFAULT NULL,
265
) ENGINE=ENGINE DEFAULT CHARSET=latin1
266
ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
270
SHOW CREATE TABLE t5;
272
t5 CREATE TABLE `t5` (
274
`c2` int(11) NOT NULL,
275
`c4` char(5) DEFAULT NULL,
276
`c3` char(10) DEFAULT NULL,
278
) ENGINE=ENGINE DEFAULT CHARSET=latin1
282
CREATE TABLE t5(c1 DECIMAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
286
SHOW CREATE TABLE t5;
288
t5 CREATE TABLE `t5` (
289
`c1` decimal(10,0) NOT NULL,
290
`c2` int(11) NOT NULL,
291
`c3` char(10) DEFAULT NULL,
293
) ENGINE=ENGINE DEFAULT CHARSET=latin1
294
ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
298
SHOW CREATE TABLE t5;
300
t5 CREATE TABLE `t5` (
301
`c1` decimal(10,0) NOT NULL,
302
`c2` int(11) NOT NULL,
303
`c4` char(5) DEFAULT NULL,
304
`c3` char(10) DEFAULT NULL,
306
) ENGINE=ENGINE DEFAULT CHARSET=latin1
310
CREATE TABLE t5(c1 NUMERIC NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
314
SHOW CREATE TABLE t5;
316
t5 CREATE TABLE `t5` (
317
`c1` decimal(10,0) NOT NULL,
318
`c2` int(11) NOT NULL,
319
`c3` char(10) DEFAULT NULL,
321
) ENGINE=ENGINE DEFAULT CHARSET=latin1
322
ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
326
SHOW CREATE TABLE t5;
328
t5 CREATE TABLE `t5` (
329
`c1` decimal(10,0) NOT NULL,
330
`c2` int(11) NOT NULL,
331
`c4` char(5) DEFAULT NULL,
332
`c3` char(10) DEFAULT NULL,
334
) ENGINE=ENGINE DEFAULT CHARSET=latin1
338
CREATE TABLE t5(c1 DATE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
342
SHOW CREATE TABLE t5;
344
t5 CREATE TABLE `t5` (
346
`c2` int(11) NOT NULL,
347
`c3` char(10) DEFAULT NULL,
349
) ENGINE=ENGINE DEFAULT CHARSET=latin1
350
ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
354
SHOW CREATE TABLE t5;
356
t5 CREATE TABLE `t5` (
358
`c2` int(11) NOT NULL,
359
`c4` char(5) DEFAULT NULL,
360
`c3` char(10) DEFAULT NULL,
362
) ENGINE=ENGINE DEFAULT CHARSET=latin1
366
CREATE TABLE t5(c1 TIME NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
370
SHOW CREATE TABLE t5;
372
t5 CREATE TABLE `t5` (
374
`c2` int(11) NOT NULL,
375
`c3` char(10) DEFAULT NULL,
377
) ENGINE=ENGINE DEFAULT CHARSET=latin1
378
ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
382
SHOW CREATE TABLE t5;
384
t5 CREATE TABLE `t5` (
386
`c2` int(11) NOT NULL,
387
`c4` char(5) DEFAULT NULL,
388
`c3` char(10) DEFAULT NULL,
390
) ENGINE=ENGINE DEFAULT CHARSET=latin1
394
CREATE TABLE t5(c1 TIMESTAMP NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
398
SHOW CREATE TABLE t5;
400
t5 CREATE TABLE `t5` (
401
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
402
`c2` int(11) NOT NULL,
403
`c3` char(10) DEFAULT NULL,
405
) ENGINE=ENGINE DEFAULT CHARSET=latin1
406
ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
410
SHOW CREATE TABLE t5;
412
t5 CREATE TABLE `t5` (
413
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
414
`c2` int(11) NOT NULL,
415
`c4` char(5) DEFAULT NULL,
416
`c3` char(10) DEFAULT NULL,
418
) ENGINE=ENGINE DEFAULT CHARSET=latin1
422
CREATE TABLE t5(c1 YEAR NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NULL);
426
SHOW CREATE TABLE t5;
428
t5 CREATE TABLE `t5` (
429
`c1` year(4) NOT NULL,
430
`c2` int(11) NOT NULL,
431
`c3` char(10) DEFAULT NULL,
433
) ENGINE=ENGINE DEFAULT CHARSET=latin1
434
ALTER TABLE t5 ADD c4 CHAR(5) NULL AFTER c2;
438
SHOW CREATE TABLE t5;
440
t5 CREATE TABLE `t5` (
441
`c1` year(4) NOT NULL,
442
`c2` int(11) NOT NULL,
443
`c4` char(5) DEFAULT NULL,
444
`c3` char(10) DEFAULT NULL,
446
) ENGINE=ENGINE DEFAULT CHARSET=latin1
450
CREATE TABLE t5(c1 BIT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
454
SHOW CREATE TABLE t5;
456
t5 CREATE TABLE `t5` (
457
`c1` bit(1) NOT NULL,
458
`c2` int(11) NOT NULL,
459
`c3` char(10) NOT NULL,
461
) ENGINE=ENGINE DEFAULT CHARSET=latin1
462
ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
466
SHOW CREATE TABLE t5;
468
t5 CREATE TABLE `t5` (
469
`c1` bit(1) NOT NULL,
470
`c2` int(11) NOT NULL,
471
`c4` char(5) NOT NULL,
472
`c3` char(10) NOT NULL,
474
) ENGINE=ENGINE DEFAULT CHARSET=latin1
478
CREATE TABLE t5(c1 TINYINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
482
SHOW CREATE TABLE t5;
484
t5 CREATE TABLE `t5` (
485
`c1` tinyint(4) NOT NULL,
486
`c2` int(11) NOT NULL,
487
`c3` char(10) NOT NULL,
489
) ENGINE=ENGINE DEFAULT CHARSET=latin1
490
ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
494
SHOW CREATE TABLE t5;
496
t5 CREATE TABLE `t5` (
497
`c1` tinyint(4) NOT NULL,
498
`c2` int(11) NOT NULL,
499
`c4` char(5) NOT NULL,
500
`c3` char(10) NOT NULL,
502
) ENGINE=ENGINE DEFAULT CHARSET=latin1
506
CREATE TABLE t5(c1 SMALLINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
510
SHOW CREATE TABLE t5;
512
t5 CREATE TABLE `t5` (
513
`c1` smallint(6) NOT NULL,
514
`c2` int(11) NOT NULL,
515
`c3` char(10) NOT NULL,
517
) ENGINE=ENGINE DEFAULT CHARSET=latin1
518
ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
522
SHOW CREATE TABLE t5;
524
t5 CREATE TABLE `t5` (
525
`c1` smallint(6) NOT NULL,
526
`c2` int(11) NOT NULL,
527
`c4` char(5) NOT NULL,
528
`c3` char(10) NOT NULL,
530
) ENGINE=ENGINE DEFAULT CHARSET=latin1
534
CREATE TABLE t5(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
538
SHOW CREATE TABLE t5;
540
t5 CREATE TABLE `t5` (
541
`c1` mediumint(9) NOT NULL,
542
`c2` int(11) NOT NULL,
543
`c3` char(10) NOT NULL,
545
) ENGINE=ENGINE DEFAULT CHARSET=latin1
546
ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
550
SHOW CREATE TABLE t5;
552
t5 CREATE TABLE `t5` (
553
`c1` mediumint(9) NOT NULL,
554
`c2` int(11) NOT NULL,
555
`c4` char(5) NOT NULL,
556
`c3` char(10) NOT NULL,
558
) ENGINE=ENGINE DEFAULT CHARSET=latin1
562
CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
566
SHOW CREATE TABLE t5;
568
t5 CREATE TABLE `t5` (
569
`c1` int(11) NOT NULL,
570
`c2` int(11) NOT NULL,
571
`c3` char(10) NOT NULL,
573
) ENGINE=ENGINE DEFAULT CHARSET=latin1
574
ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
578
SHOW CREATE TABLE t5;
580
t5 CREATE TABLE `t5` (
581
`c1` int(11) NOT NULL,
582
`c2` int(11) NOT NULL,
583
`c4` char(5) NOT NULL,
584
`c3` char(10) NOT NULL,
586
) ENGINE=ENGINE DEFAULT CHARSET=latin1
590
CREATE TABLE t5(c1 INTEGER NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
594
SHOW CREATE TABLE t5;
596
t5 CREATE TABLE `t5` (
597
`c1` int(11) NOT NULL,
598
`c2` int(11) NOT NULL,
599
`c3` char(10) NOT NULL,
601
) ENGINE=ENGINE DEFAULT CHARSET=latin1
602
ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
606
SHOW CREATE TABLE t5;
608
t5 CREATE TABLE `t5` (
609
`c1` int(11) NOT NULL,
610
`c2` int(11) NOT NULL,
611
`c4` char(5) NOT NULL,
612
`c3` char(10) NOT NULL,
614
) ENGINE=ENGINE DEFAULT CHARSET=latin1
618
CREATE TABLE t5(c1 BIGINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
622
SHOW CREATE TABLE t5;
624
t5 CREATE TABLE `t5` (
625
`c1` bigint(20) NOT NULL,
626
`c2` int(11) NOT NULL,
627
`c3` char(10) NOT NULL,
629
) ENGINE=ENGINE DEFAULT CHARSET=latin1
630
ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
634
SHOW CREATE TABLE t5;
636
t5 CREATE TABLE `t5` (
637
`c1` bigint(20) NOT NULL,
638
`c2` int(11) NOT NULL,
639
`c4` char(5) NOT NULL,
640
`c3` char(10) NOT NULL,
642
) ENGINE=ENGINE DEFAULT CHARSET=latin1
646
CREATE TABLE t5(c1 REAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
650
SHOW CREATE TABLE t5;
652
t5 CREATE TABLE `t5` (
653
`c1` double NOT NULL,
654
`c2` int(11) NOT NULL,
655
`c3` char(10) NOT NULL,
657
) ENGINE=ENGINE DEFAULT CHARSET=latin1
658
ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
662
SHOW CREATE TABLE t5;
664
t5 CREATE TABLE `t5` (
665
`c1` double NOT NULL,
666
`c2` int(11) NOT NULL,
667
`c4` char(5) NOT NULL,
668
`c3` char(10) NOT NULL,
670
) ENGINE=ENGINE DEFAULT CHARSET=latin1
674
CREATE TABLE t5(c1 DOUBLE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
678
SHOW CREATE TABLE t5;
680
t5 CREATE TABLE `t5` (
681
`c1` double NOT NULL,
682
`c2` int(11) NOT NULL,
683
`c3` char(10) NOT NULL,
685
) ENGINE=ENGINE DEFAULT CHARSET=latin1
686
ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
690
SHOW CREATE TABLE t5;
692
t5 CREATE TABLE `t5` (
693
`c1` double NOT NULL,
694
`c2` int(11) NOT NULL,
695
`c4` char(5) NOT NULL,
696
`c3` char(10) NOT NULL,
698
) ENGINE=ENGINE DEFAULT CHARSET=latin1
702
CREATE TABLE t5(c1 FLOAT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
706
SHOW CREATE TABLE t5;
708
t5 CREATE TABLE `t5` (
710
`c2` int(11) NOT NULL,
711
`c3` char(10) NOT NULL,
713
) ENGINE=ENGINE DEFAULT CHARSET=latin1
714
ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
718
SHOW CREATE TABLE t5;
720
t5 CREATE TABLE `t5` (
722
`c2` int(11) NOT NULL,
723
`c4` char(5) NOT NULL,
724
`c3` char(10) NOT NULL,
726
) ENGINE=ENGINE DEFAULT CHARSET=latin1
730
CREATE TABLE t5(c1 DECIMAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
734
SHOW CREATE TABLE t5;
736
t5 CREATE TABLE `t5` (
737
`c1` decimal(10,0) NOT NULL,
738
`c2` int(11) NOT NULL,
739
`c3` char(10) NOT NULL,
741
) ENGINE=ENGINE DEFAULT CHARSET=latin1
742
ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
746
SHOW CREATE TABLE t5;
748
t5 CREATE TABLE `t5` (
749
`c1` decimal(10,0) NOT NULL,
750
`c2` int(11) NOT NULL,
751
`c4` char(5) NOT NULL,
752
`c3` char(10) NOT NULL,
754
) ENGINE=ENGINE DEFAULT CHARSET=latin1
758
CREATE TABLE t5(c1 NUMERIC NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
762
SHOW CREATE TABLE t5;
764
t5 CREATE TABLE `t5` (
765
`c1` decimal(10,0) NOT NULL,
766
`c2` int(11) NOT NULL,
767
`c3` char(10) NOT NULL,
769
) ENGINE=ENGINE DEFAULT CHARSET=latin1
770
ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
774
SHOW CREATE TABLE t5;
776
t5 CREATE TABLE `t5` (
777
`c1` decimal(10,0) NOT NULL,
778
`c2` int(11) NOT NULL,
779
`c4` char(5) NOT NULL,
780
`c3` char(10) NOT NULL,
782
) ENGINE=ENGINE DEFAULT CHARSET=latin1
786
CREATE TABLE t5(c1 DATE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
790
SHOW CREATE TABLE t5;
792
t5 CREATE TABLE `t5` (
794
`c2` int(11) NOT NULL,
795
`c3` char(10) NOT NULL,
797
) ENGINE=ENGINE DEFAULT CHARSET=latin1
798
ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
802
SHOW CREATE TABLE t5;
804
t5 CREATE TABLE `t5` (
806
`c2` int(11) NOT NULL,
807
`c4` char(5) NOT NULL,
808
`c3` char(10) NOT NULL,
810
) ENGINE=ENGINE DEFAULT CHARSET=latin1
814
CREATE TABLE t5(c1 TIME NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
818
SHOW CREATE TABLE t5;
820
t5 CREATE TABLE `t5` (
822
`c2` int(11) NOT NULL,
823
`c3` char(10) NOT NULL,
825
) ENGINE=ENGINE DEFAULT CHARSET=latin1
826
ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
830
SHOW CREATE TABLE t5;
832
t5 CREATE TABLE `t5` (
834
`c2` int(11) NOT NULL,
835
`c4` char(5) NOT NULL,
836
`c3` char(10) NOT NULL,
838
) ENGINE=ENGINE DEFAULT CHARSET=latin1
842
CREATE TABLE t5(c1 TIMESTAMP NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
846
SHOW CREATE TABLE t5;
848
t5 CREATE TABLE `t5` (
849
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
850
`c2` int(11) NOT NULL,
851
`c3` char(10) NOT NULL,
853
) ENGINE=ENGINE DEFAULT CHARSET=latin1
854
ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
858
SHOW CREATE TABLE t5;
860
t5 CREATE TABLE `t5` (
861
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
862
`c2` int(11) NOT NULL,
863
`c4` char(5) NOT NULL,
864
`c3` char(10) NOT NULL,
866
) ENGINE=ENGINE DEFAULT CHARSET=latin1
870
CREATE TABLE t5(c1 YEAR NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(10) NOT NULL);
874
SHOW CREATE TABLE t5;
876
t5 CREATE TABLE `t5` (
877
`c1` year(4) NOT NULL,
878
`c2` int(11) NOT NULL,
879
`c3` char(10) NOT NULL,
881
) ENGINE=ENGINE DEFAULT CHARSET=latin1
882
ALTER TABLE t5 ADD c4 CHAR(5) NOT NULL AFTER c2;
886
SHOW CREATE TABLE t5;
888
t5 CREATE TABLE `t5` (
889
`c1` year(4) NOT NULL,
890
`c2` int(11) NOT NULL,
891
`c4` char(5) NOT NULL,
892
`c3` char(10) NOT NULL,
894
) ENGINE=ENGINE DEFAULT CHARSET=latin1
898
CREATE TABLE t5(c1 BIT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
902
SHOW CREATE TABLE t5;
904
t5 CREATE TABLE `t5` (
905
`c1` bit(1) NOT NULL,
906
`c2` int(11) NOT NULL,
907
`c3` varchar(10) DEFAULT NULL,
909
) ENGINE=ENGINE DEFAULT CHARSET=latin1
910
ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
914
SHOW CREATE TABLE t5;
916
t5 CREATE TABLE `t5` (
917
`c1` bit(1) NOT NULL,
918
`c2` int(11) NOT NULL,
919
`c4` varchar(5) DEFAULT NULL,
920
`c3` varchar(10) DEFAULT NULL,
922
) ENGINE=ENGINE DEFAULT CHARSET=latin1
926
CREATE TABLE t5(c1 TINYINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
930
SHOW CREATE TABLE t5;
932
t5 CREATE TABLE `t5` (
933
`c1` tinyint(4) NOT NULL,
934
`c2` int(11) NOT NULL,
935
`c3` varchar(10) DEFAULT NULL,
937
) ENGINE=ENGINE DEFAULT CHARSET=latin1
938
ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
942
SHOW CREATE TABLE t5;
944
t5 CREATE TABLE `t5` (
945
`c1` tinyint(4) NOT NULL,
946
`c2` int(11) NOT NULL,
947
`c4` varchar(5) DEFAULT NULL,
948
`c3` varchar(10) DEFAULT NULL,
950
) ENGINE=ENGINE DEFAULT CHARSET=latin1
954
CREATE TABLE t5(c1 SMALLINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
958
SHOW CREATE TABLE t5;
960
t5 CREATE TABLE `t5` (
961
`c1` smallint(6) NOT NULL,
962
`c2` int(11) NOT NULL,
963
`c3` varchar(10) DEFAULT NULL,
965
) ENGINE=ENGINE DEFAULT CHARSET=latin1
966
ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
970
SHOW CREATE TABLE t5;
972
t5 CREATE TABLE `t5` (
973
`c1` smallint(6) NOT NULL,
974
`c2` int(11) NOT NULL,
975
`c4` varchar(5) DEFAULT NULL,
976
`c3` varchar(10) DEFAULT NULL,
978
) ENGINE=ENGINE DEFAULT CHARSET=latin1
982
CREATE TABLE t5(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
986
SHOW CREATE TABLE t5;
988
t5 CREATE TABLE `t5` (
989
`c1` mediumint(9) NOT NULL,
990
`c2` int(11) NOT NULL,
991
`c3` varchar(10) DEFAULT NULL,
993
) ENGINE=ENGINE DEFAULT CHARSET=latin1
994
ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
998
SHOW CREATE TABLE t5;
1000
t5 CREATE TABLE `t5` (
1001
`c1` mediumint(9) NOT NULL,
1002
`c2` int(11) NOT NULL,
1003
`c4` varchar(5) DEFAULT NULL,
1004
`c3` varchar(10) DEFAULT NULL,
1006
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1010
CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1014
SHOW CREATE TABLE t5;
1016
t5 CREATE TABLE `t5` (
1017
`c1` int(11) NOT NULL,
1018
`c2` int(11) NOT NULL,
1019
`c3` varchar(10) DEFAULT NULL,
1021
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1022
ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1026
SHOW CREATE TABLE t5;
1028
t5 CREATE TABLE `t5` (
1029
`c1` int(11) NOT NULL,
1030
`c2` int(11) NOT NULL,
1031
`c4` varchar(5) DEFAULT NULL,
1032
`c3` varchar(10) DEFAULT NULL,
1034
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1038
CREATE TABLE t5(c1 INTEGER NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1042
SHOW CREATE TABLE t5;
1044
t5 CREATE TABLE `t5` (
1045
`c1` int(11) NOT NULL,
1046
`c2` int(11) NOT NULL,
1047
`c3` varchar(10) DEFAULT NULL,
1049
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1050
ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1054
SHOW CREATE TABLE t5;
1056
t5 CREATE TABLE `t5` (
1057
`c1` int(11) NOT NULL,
1058
`c2` int(11) NOT NULL,
1059
`c4` varchar(5) DEFAULT NULL,
1060
`c3` varchar(10) DEFAULT NULL,
1062
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1066
CREATE TABLE t5(c1 BIGINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1070
SHOW CREATE TABLE t5;
1072
t5 CREATE TABLE `t5` (
1073
`c1` bigint(20) NOT NULL,
1074
`c2` int(11) NOT NULL,
1075
`c3` varchar(10) DEFAULT NULL,
1077
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1078
ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1082
SHOW CREATE TABLE t5;
1084
t5 CREATE TABLE `t5` (
1085
`c1` bigint(20) NOT NULL,
1086
`c2` int(11) NOT NULL,
1087
`c4` varchar(5) DEFAULT NULL,
1088
`c3` varchar(10) DEFAULT NULL,
1090
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1094
CREATE TABLE t5(c1 REAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1098
SHOW CREATE TABLE t5;
1100
t5 CREATE TABLE `t5` (
1101
`c1` double NOT NULL,
1102
`c2` int(11) NOT NULL,
1103
`c3` varchar(10) DEFAULT NULL,
1105
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1106
ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1110
SHOW CREATE TABLE t5;
1112
t5 CREATE TABLE `t5` (
1113
`c1` double NOT NULL,
1114
`c2` int(11) NOT NULL,
1115
`c4` varchar(5) DEFAULT NULL,
1116
`c3` varchar(10) DEFAULT NULL,
1118
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1122
CREATE TABLE t5(c1 DOUBLE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1126
SHOW CREATE TABLE t5;
1128
t5 CREATE TABLE `t5` (
1129
`c1` double NOT NULL,
1130
`c2` int(11) NOT NULL,
1131
`c3` varchar(10) DEFAULT NULL,
1133
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1134
ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1138
SHOW CREATE TABLE t5;
1140
t5 CREATE TABLE `t5` (
1141
`c1` double NOT NULL,
1142
`c2` int(11) NOT NULL,
1143
`c4` varchar(5) DEFAULT NULL,
1144
`c3` varchar(10) DEFAULT NULL,
1146
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1150
CREATE TABLE t5(c1 FLOAT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1154
SHOW CREATE TABLE t5;
1156
t5 CREATE TABLE `t5` (
1157
`c1` float NOT NULL,
1158
`c2` int(11) NOT NULL,
1159
`c3` varchar(10) DEFAULT NULL,
1161
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1162
ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1166
SHOW CREATE TABLE t5;
1168
t5 CREATE TABLE `t5` (
1169
`c1` float NOT NULL,
1170
`c2` int(11) NOT NULL,
1171
`c4` varchar(5) DEFAULT NULL,
1172
`c3` varchar(10) DEFAULT NULL,
1174
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1178
CREATE TABLE t5(c1 DECIMAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1182
SHOW CREATE TABLE t5;
1184
t5 CREATE TABLE `t5` (
1185
`c1` decimal(10,0) NOT NULL,
1186
`c2` int(11) NOT NULL,
1187
`c3` varchar(10) DEFAULT NULL,
1189
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1190
ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1194
SHOW CREATE TABLE t5;
1196
t5 CREATE TABLE `t5` (
1197
`c1` decimal(10,0) NOT NULL,
1198
`c2` int(11) NOT NULL,
1199
`c4` varchar(5) DEFAULT NULL,
1200
`c3` varchar(10) DEFAULT NULL,
1202
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1206
CREATE TABLE t5(c1 NUMERIC NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1210
SHOW CREATE TABLE t5;
1212
t5 CREATE TABLE `t5` (
1213
`c1` decimal(10,0) NOT NULL,
1214
`c2` int(11) NOT NULL,
1215
`c3` varchar(10) DEFAULT NULL,
1217
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1218
ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1222
SHOW CREATE TABLE t5;
1224
t5 CREATE TABLE `t5` (
1225
`c1` decimal(10,0) NOT NULL,
1226
`c2` int(11) NOT NULL,
1227
`c4` varchar(5) DEFAULT NULL,
1228
`c3` varchar(10) DEFAULT NULL,
1230
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1234
CREATE TABLE t5(c1 DATE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1238
SHOW CREATE TABLE t5;
1240
t5 CREATE TABLE `t5` (
1242
`c2` int(11) NOT NULL,
1243
`c3` varchar(10) DEFAULT NULL,
1245
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1246
ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1250
SHOW CREATE TABLE t5;
1252
t5 CREATE TABLE `t5` (
1254
`c2` int(11) NOT NULL,
1255
`c4` varchar(5) DEFAULT NULL,
1256
`c3` varchar(10) DEFAULT NULL,
1258
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1262
CREATE TABLE t5(c1 TIME NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1266
SHOW CREATE TABLE t5;
1268
t5 CREATE TABLE `t5` (
1270
`c2` int(11) NOT NULL,
1271
`c3` varchar(10) DEFAULT NULL,
1273
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1274
ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1278
SHOW CREATE TABLE t5;
1280
t5 CREATE TABLE `t5` (
1282
`c2` int(11) NOT NULL,
1283
`c4` varchar(5) DEFAULT NULL,
1284
`c3` varchar(10) DEFAULT NULL,
1286
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1290
CREATE TABLE t5(c1 TIMESTAMP NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1294
SHOW CREATE TABLE t5;
1296
t5 CREATE TABLE `t5` (
1297
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1298
`c2` int(11) NOT NULL,
1299
`c3` varchar(10) DEFAULT NULL,
1301
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1302
ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1306
SHOW CREATE TABLE t5;
1308
t5 CREATE TABLE `t5` (
1309
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1310
`c2` int(11) NOT NULL,
1311
`c4` varchar(5) DEFAULT NULL,
1312
`c3` varchar(10) DEFAULT NULL,
1314
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1318
CREATE TABLE t5(c1 YEAR NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NULL);
1322
SHOW CREATE TABLE t5;
1324
t5 CREATE TABLE `t5` (
1325
`c1` year(4) NOT NULL,
1326
`c2` int(11) NOT NULL,
1327
`c3` varchar(10) DEFAULT NULL,
1329
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1330
ALTER TABLE t5 ADD c4 VARCHAR(5) NULL AFTER c2;
1334
SHOW CREATE TABLE t5;
1336
t5 CREATE TABLE `t5` (
1337
`c1` year(4) NOT NULL,
1338
`c2` int(11) NOT NULL,
1339
`c4` varchar(5) DEFAULT NULL,
1340
`c3` varchar(10) DEFAULT NULL,
1342
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1346
CREATE TABLE t5(c1 BIT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1350
SHOW CREATE TABLE t5;
1352
t5 CREATE TABLE `t5` (
1353
`c1` bit(1) NOT NULL,
1354
`c2` int(11) NOT NULL,
1355
`c3` varchar(10) NOT NULL,
1357
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1358
ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1362
SHOW CREATE TABLE t5;
1364
t5 CREATE TABLE `t5` (
1365
`c1` bit(1) NOT NULL,
1366
`c2` int(11) NOT NULL,
1367
`c4` varchar(5) NOT NULL,
1368
`c3` varchar(10) NOT NULL,
1370
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1374
CREATE TABLE t5(c1 TINYINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1378
SHOW CREATE TABLE t5;
1380
t5 CREATE TABLE `t5` (
1381
`c1` tinyint(4) NOT NULL,
1382
`c2` int(11) NOT NULL,
1383
`c3` varchar(10) NOT NULL,
1385
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1386
ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1390
SHOW CREATE TABLE t5;
1392
t5 CREATE TABLE `t5` (
1393
`c1` tinyint(4) NOT NULL,
1394
`c2` int(11) NOT NULL,
1395
`c4` varchar(5) NOT NULL,
1396
`c3` varchar(10) NOT NULL,
1398
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1402
CREATE TABLE t5(c1 SMALLINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1406
SHOW CREATE TABLE t5;
1408
t5 CREATE TABLE `t5` (
1409
`c1` smallint(6) NOT NULL,
1410
`c2` int(11) NOT NULL,
1411
`c3` varchar(10) NOT NULL,
1413
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1414
ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1418
SHOW CREATE TABLE t5;
1420
t5 CREATE TABLE `t5` (
1421
`c1` smallint(6) NOT NULL,
1422
`c2` int(11) NOT NULL,
1423
`c4` varchar(5) NOT NULL,
1424
`c3` varchar(10) NOT NULL,
1426
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1430
CREATE TABLE t5(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1434
SHOW CREATE TABLE t5;
1436
t5 CREATE TABLE `t5` (
1437
`c1` mediumint(9) NOT NULL,
1438
`c2` int(11) NOT NULL,
1439
`c3` varchar(10) NOT NULL,
1441
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1442
ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1446
SHOW CREATE TABLE t5;
1448
t5 CREATE TABLE `t5` (
1449
`c1` mediumint(9) NOT NULL,
1450
`c2` int(11) NOT NULL,
1451
`c4` varchar(5) NOT NULL,
1452
`c3` varchar(10) NOT NULL,
1454
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1458
CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1462
SHOW CREATE TABLE t5;
1464
t5 CREATE TABLE `t5` (
1465
`c1` int(11) NOT NULL,
1466
`c2` int(11) NOT NULL,
1467
`c3` varchar(10) NOT NULL,
1469
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1470
ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1474
SHOW CREATE TABLE t5;
1476
t5 CREATE TABLE `t5` (
1477
`c1` int(11) NOT NULL,
1478
`c2` int(11) NOT NULL,
1479
`c4` varchar(5) NOT NULL,
1480
`c3` varchar(10) NOT NULL,
1482
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1486
CREATE TABLE t5(c1 INTEGER NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1490
SHOW CREATE TABLE t5;
1492
t5 CREATE TABLE `t5` (
1493
`c1` int(11) NOT NULL,
1494
`c2` int(11) NOT NULL,
1495
`c3` varchar(10) NOT NULL,
1497
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1498
ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1502
SHOW CREATE TABLE t5;
1504
t5 CREATE TABLE `t5` (
1505
`c1` int(11) NOT NULL,
1506
`c2` int(11) NOT NULL,
1507
`c4` varchar(5) NOT NULL,
1508
`c3` varchar(10) NOT NULL,
1510
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1514
CREATE TABLE t5(c1 BIGINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1518
SHOW CREATE TABLE t5;
1520
t5 CREATE TABLE `t5` (
1521
`c1` bigint(20) NOT NULL,
1522
`c2` int(11) NOT NULL,
1523
`c3` varchar(10) NOT NULL,
1525
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1526
ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1530
SHOW CREATE TABLE t5;
1532
t5 CREATE TABLE `t5` (
1533
`c1` bigint(20) NOT NULL,
1534
`c2` int(11) NOT NULL,
1535
`c4` varchar(5) NOT NULL,
1536
`c3` varchar(10) NOT NULL,
1538
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1542
CREATE TABLE t5(c1 REAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1546
SHOW CREATE TABLE t5;
1548
t5 CREATE TABLE `t5` (
1549
`c1` double NOT NULL,
1550
`c2` int(11) NOT NULL,
1551
`c3` varchar(10) NOT NULL,
1553
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1554
ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1558
SHOW CREATE TABLE t5;
1560
t5 CREATE TABLE `t5` (
1561
`c1` double NOT NULL,
1562
`c2` int(11) NOT NULL,
1563
`c4` varchar(5) NOT NULL,
1564
`c3` varchar(10) NOT NULL,
1566
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1570
CREATE TABLE t5(c1 DOUBLE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1574
SHOW CREATE TABLE t5;
1576
t5 CREATE TABLE `t5` (
1577
`c1` double NOT NULL,
1578
`c2` int(11) NOT NULL,
1579
`c3` varchar(10) NOT NULL,
1581
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1582
ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1586
SHOW CREATE TABLE t5;
1588
t5 CREATE TABLE `t5` (
1589
`c1` double NOT NULL,
1590
`c2` int(11) NOT NULL,
1591
`c4` varchar(5) NOT NULL,
1592
`c3` varchar(10) NOT NULL,
1594
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1598
CREATE TABLE t5(c1 FLOAT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1602
SHOW CREATE TABLE t5;
1604
t5 CREATE TABLE `t5` (
1605
`c1` float NOT NULL,
1606
`c2` int(11) NOT NULL,
1607
`c3` varchar(10) NOT NULL,
1609
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1610
ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1614
SHOW CREATE TABLE t5;
1616
t5 CREATE TABLE `t5` (
1617
`c1` float NOT NULL,
1618
`c2` int(11) NOT NULL,
1619
`c4` varchar(5) NOT NULL,
1620
`c3` varchar(10) NOT NULL,
1622
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1626
CREATE TABLE t5(c1 DECIMAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1630
SHOW CREATE TABLE t5;
1632
t5 CREATE TABLE `t5` (
1633
`c1` decimal(10,0) NOT NULL,
1634
`c2` int(11) NOT NULL,
1635
`c3` varchar(10) NOT NULL,
1637
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1638
ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1642
SHOW CREATE TABLE t5;
1644
t5 CREATE TABLE `t5` (
1645
`c1` decimal(10,0) NOT NULL,
1646
`c2` int(11) NOT NULL,
1647
`c4` varchar(5) NOT NULL,
1648
`c3` varchar(10) NOT NULL,
1650
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1654
CREATE TABLE t5(c1 NUMERIC NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1658
SHOW CREATE TABLE t5;
1660
t5 CREATE TABLE `t5` (
1661
`c1` decimal(10,0) NOT NULL,
1662
`c2` int(11) NOT NULL,
1663
`c3` varchar(10) NOT NULL,
1665
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1666
ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1670
SHOW CREATE TABLE t5;
1672
t5 CREATE TABLE `t5` (
1673
`c1` decimal(10,0) NOT NULL,
1674
`c2` int(11) NOT NULL,
1675
`c4` varchar(5) NOT NULL,
1676
`c3` varchar(10) NOT NULL,
1678
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1682
CREATE TABLE t5(c1 DATE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1686
SHOW CREATE TABLE t5;
1688
t5 CREATE TABLE `t5` (
1690
`c2` int(11) NOT NULL,
1691
`c3` varchar(10) NOT NULL,
1693
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1694
ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1698
SHOW CREATE TABLE t5;
1700
t5 CREATE TABLE `t5` (
1702
`c2` int(11) NOT NULL,
1703
`c4` varchar(5) NOT NULL,
1704
`c3` varchar(10) NOT NULL,
1706
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1710
CREATE TABLE t5(c1 TIME NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1714
SHOW CREATE TABLE t5;
1716
t5 CREATE TABLE `t5` (
1718
`c2` int(11) NOT NULL,
1719
`c3` varchar(10) NOT NULL,
1721
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1722
ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1726
SHOW CREATE TABLE t5;
1728
t5 CREATE TABLE `t5` (
1730
`c2` int(11) NOT NULL,
1731
`c4` varchar(5) NOT NULL,
1732
`c3` varchar(10) NOT NULL,
1734
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1738
CREATE TABLE t5(c1 TIMESTAMP NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1742
SHOW CREATE TABLE t5;
1744
t5 CREATE TABLE `t5` (
1745
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1746
`c2` int(11) NOT NULL,
1747
`c3` varchar(10) NOT NULL,
1749
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1750
ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1754
SHOW CREATE TABLE t5;
1756
t5 CREATE TABLE `t5` (
1757
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1758
`c2` int(11) NOT NULL,
1759
`c4` varchar(5) NOT NULL,
1760
`c3` varchar(10) NOT NULL,
1762
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1766
CREATE TABLE t5(c1 YEAR NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(10) NOT NULL);
1770
SHOW CREATE TABLE t5;
1772
t5 CREATE TABLE `t5` (
1773
`c1` year(4) NOT NULL,
1774
`c2` int(11) NOT NULL,
1775
`c3` varchar(10) NOT NULL,
1777
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1778
ALTER TABLE t5 ADD c4 VARCHAR(5) NOT NULL AFTER c2;
1782
SHOW CREATE TABLE t5;
1784
t5 CREATE TABLE `t5` (
1785
`c1` year(4) NOT NULL,
1786
`c2` int(11) NOT NULL,
1787
`c4` varchar(5) NOT NULL,
1788
`c3` varchar(10) NOT NULL,
1790
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1794
CREATE TABLE t5(c1 BIT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
1798
SHOW CREATE TABLE t5;
1800
t5 CREATE TABLE `t5` (
1801
`c1` bit(1) NOT NULL,
1802
`c2` int(11) NOT NULL,
1803
`c3` binary(10) DEFAULT NULL,
1805
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1806
ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
1810
SHOW CREATE TABLE t5;
1812
t5 CREATE TABLE `t5` (
1813
`c1` bit(1) NOT NULL,
1814
`c2` int(11) NOT NULL,
1815
`c4` binary(5) DEFAULT NULL,
1816
`c3` binary(10) DEFAULT NULL,
1818
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1822
CREATE TABLE t5(c1 TINYINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
1826
SHOW CREATE TABLE t5;
1828
t5 CREATE TABLE `t5` (
1829
`c1` tinyint(4) NOT NULL,
1830
`c2` int(11) NOT NULL,
1831
`c3` binary(10) DEFAULT NULL,
1833
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1834
ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
1838
SHOW CREATE TABLE t5;
1840
t5 CREATE TABLE `t5` (
1841
`c1` tinyint(4) NOT NULL,
1842
`c2` int(11) NOT NULL,
1843
`c4` binary(5) DEFAULT NULL,
1844
`c3` binary(10) DEFAULT NULL,
1846
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1850
CREATE TABLE t5(c1 SMALLINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
1854
SHOW CREATE TABLE t5;
1856
t5 CREATE TABLE `t5` (
1857
`c1` smallint(6) NOT NULL,
1858
`c2` int(11) NOT NULL,
1859
`c3` binary(10) DEFAULT NULL,
1861
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1862
ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
1866
SHOW CREATE TABLE t5;
1868
t5 CREATE TABLE `t5` (
1869
`c1` smallint(6) NOT NULL,
1870
`c2` int(11) NOT NULL,
1871
`c4` binary(5) DEFAULT NULL,
1872
`c3` binary(10) DEFAULT NULL,
1874
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1878
CREATE TABLE t5(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
1882
SHOW CREATE TABLE t5;
1884
t5 CREATE TABLE `t5` (
1885
`c1` mediumint(9) NOT NULL,
1886
`c2` int(11) NOT NULL,
1887
`c3` binary(10) DEFAULT NULL,
1889
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1890
ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
1894
SHOW CREATE TABLE t5;
1896
t5 CREATE TABLE `t5` (
1897
`c1` mediumint(9) NOT NULL,
1898
`c2` int(11) NOT NULL,
1899
`c4` binary(5) DEFAULT NULL,
1900
`c3` binary(10) DEFAULT NULL,
1902
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1906
CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
1910
SHOW CREATE TABLE t5;
1912
t5 CREATE TABLE `t5` (
1913
`c1` int(11) NOT NULL,
1914
`c2` int(11) NOT NULL,
1915
`c3` binary(10) DEFAULT NULL,
1917
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1918
ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
1922
SHOW CREATE TABLE t5;
1924
t5 CREATE TABLE `t5` (
1925
`c1` int(11) NOT NULL,
1926
`c2` int(11) NOT NULL,
1927
`c4` binary(5) DEFAULT NULL,
1928
`c3` binary(10) DEFAULT NULL,
1930
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1934
CREATE TABLE t5(c1 INTEGER NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
1938
SHOW CREATE TABLE t5;
1940
t5 CREATE TABLE `t5` (
1941
`c1` int(11) NOT NULL,
1942
`c2` int(11) NOT NULL,
1943
`c3` binary(10) DEFAULT NULL,
1945
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1946
ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
1950
SHOW CREATE TABLE t5;
1952
t5 CREATE TABLE `t5` (
1953
`c1` int(11) NOT NULL,
1954
`c2` int(11) NOT NULL,
1955
`c4` binary(5) DEFAULT NULL,
1956
`c3` binary(10) DEFAULT NULL,
1958
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1962
CREATE TABLE t5(c1 BIGINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
1966
SHOW CREATE TABLE t5;
1968
t5 CREATE TABLE `t5` (
1969
`c1` bigint(20) NOT NULL,
1970
`c2` int(11) NOT NULL,
1971
`c3` binary(10) DEFAULT NULL,
1973
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1974
ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
1978
SHOW CREATE TABLE t5;
1980
t5 CREATE TABLE `t5` (
1981
`c1` bigint(20) NOT NULL,
1982
`c2` int(11) NOT NULL,
1983
`c4` binary(5) DEFAULT NULL,
1984
`c3` binary(10) DEFAULT NULL,
1986
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1990
CREATE TABLE t5(c1 REAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
1994
SHOW CREATE TABLE t5;
1996
t5 CREATE TABLE `t5` (
1997
`c1` double NOT NULL,
1998
`c2` int(11) NOT NULL,
1999
`c3` binary(10) DEFAULT NULL,
2001
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2002
ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2006
SHOW CREATE TABLE t5;
2008
t5 CREATE TABLE `t5` (
2009
`c1` double NOT NULL,
2010
`c2` int(11) NOT NULL,
2011
`c4` binary(5) DEFAULT NULL,
2012
`c3` binary(10) DEFAULT NULL,
2014
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2018
CREATE TABLE t5(c1 DOUBLE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
2022
SHOW CREATE TABLE t5;
2024
t5 CREATE TABLE `t5` (
2025
`c1` double NOT NULL,
2026
`c2` int(11) NOT NULL,
2027
`c3` binary(10) DEFAULT NULL,
2029
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2030
ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2034
SHOW CREATE TABLE t5;
2036
t5 CREATE TABLE `t5` (
2037
`c1` double NOT NULL,
2038
`c2` int(11) NOT NULL,
2039
`c4` binary(5) DEFAULT NULL,
2040
`c3` binary(10) DEFAULT NULL,
2042
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2046
CREATE TABLE t5(c1 FLOAT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
2050
SHOW CREATE TABLE t5;
2052
t5 CREATE TABLE `t5` (
2053
`c1` float NOT NULL,
2054
`c2` int(11) NOT NULL,
2055
`c3` binary(10) DEFAULT NULL,
2057
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2058
ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2062
SHOW CREATE TABLE t5;
2064
t5 CREATE TABLE `t5` (
2065
`c1` float NOT NULL,
2066
`c2` int(11) NOT NULL,
2067
`c4` binary(5) DEFAULT NULL,
2068
`c3` binary(10) DEFAULT NULL,
2070
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2074
CREATE TABLE t5(c1 DECIMAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
2078
SHOW CREATE TABLE t5;
2080
t5 CREATE TABLE `t5` (
2081
`c1` decimal(10,0) NOT NULL,
2082
`c2` int(11) NOT NULL,
2083
`c3` binary(10) DEFAULT NULL,
2085
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2086
ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2090
SHOW CREATE TABLE t5;
2092
t5 CREATE TABLE `t5` (
2093
`c1` decimal(10,0) NOT NULL,
2094
`c2` int(11) NOT NULL,
2095
`c4` binary(5) DEFAULT NULL,
2096
`c3` binary(10) DEFAULT NULL,
2098
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2102
CREATE TABLE t5(c1 NUMERIC NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
2106
SHOW CREATE TABLE t5;
2108
t5 CREATE TABLE `t5` (
2109
`c1` decimal(10,0) NOT NULL,
2110
`c2` int(11) NOT NULL,
2111
`c3` binary(10) DEFAULT NULL,
2113
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2114
ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2118
SHOW CREATE TABLE t5;
2120
t5 CREATE TABLE `t5` (
2121
`c1` decimal(10,0) NOT NULL,
2122
`c2` int(11) NOT NULL,
2123
`c4` binary(5) DEFAULT NULL,
2124
`c3` binary(10) DEFAULT NULL,
2126
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2130
CREATE TABLE t5(c1 DATE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
2134
SHOW CREATE TABLE t5;
2136
t5 CREATE TABLE `t5` (
2138
`c2` int(11) NOT NULL,
2139
`c3` binary(10) DEFAULT NULL,
2141
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2142
ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2146
SHOW CREATE TABLE t5;
2148
t5 CREATE TABLE `t5` (
2150
`c2` int(11) NOT NULL,
2151
`c4` binary(5) DEFAULT NULL,
2152
`c3` binary(10) DEFAULT NULL,
2154
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2158
CREATE TABLE t5(c1 TIME NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
2162
SHOW CREATE TABLE t5;
2164
t5 CREATE TABLE `t5` (
2166
`c2` int(11) NOT NULL,
2167
`c3` binary(10) DEFAULT NULL,
2169
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2170
ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2174
SHOW CREATE TABLE t5;
2176
t5 CREATE TABLE `t5` (
2178
`c2` int(11) NOT NULL,
2179
`c4` binary(5) DEFAULT NULL,
2180
`c3` binary(10) DEFAULT NULL,
2182
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2186
CREATE TABLE t5(c1 TIMESTAMP NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
2190
SHOW CREATE TABLE t5;
2192
t5 CREATE TABLE `t5` (
2193
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2194
`c2` int(11) NOT NULL,
2195
`c3` binary(10) DEFAULT NULL,
2197
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2198
ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2202
SHOW CREATE TABLE t5;
2204
t5 CREATE TABLE `t5` (
2205
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2206
`c2` int(11) NOT NULL,
2207
`c4` binary(5) DEFAULT NULL,
2208
`c3` binary(10) DEFAULT NULL,
2210
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2214
CREATE TABLE t5(c1 YEAR NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NULL);
2218
SHOW CREATE TABLE t5;
2220
t5 CREATE TABLE `t5` (
2221
`c1` year(4) NOT NULL,
2222
`c2` int(11) NOT NULL,
2223
`c3` binary(10) DEFAULT NULL,
2225
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2226
ALTER TABLE t5 ADD c4 BINARY(5) NULL AFTER c2;
2230
SHOW CREATE TABLE t5;
2232
t5 CREATE TABLE `t5` (
2233
`c1` year(4) NOT NULL,
2234
`c2` int(11) NOT NULL,
2235
`c4` binary(5) DEFAULT NULL,
2236
`c3` binary(10) DEFAULT NULL,
2238
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2242
CREATE TABLE t5(c1 BIT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2246
SHOW CREATE TABLE t5;
2248
t5 CREATE TABLE `t5` (
2249
`c1` bit(1) NOT NULL,
2250
`c2` int(11) NOT NULL,
2251
`c3` binary(10) NOT NULL,
2253
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2254
ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2258
SHOW CREATE TABLE t5;
2260
t5 CREATE TABLE `t5` (
2261
`c1` bit(1) NOT NULL,
2262
`c2` int(11) NOT NULL,
2263
`c4` binary(5) NOT NULL,
2264
`c3` binary(10) NOT NULL,
2266
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2270
CREATE TABLE t5(c1 TINYINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2274
SHOW CREATE TABLE t5;
2276
t5 CREATE TABLE `t5` (
2277
`c1` tinyint(4) NOT NULL,
2278
`c2` int(11) NOT NULL,
2279
`c3` binary(10) NOT NULL,
2281
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2282
ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2286
SHOW CREATE TABLE t5;
2288
t5 CREATE TABLE `t5` (
2289
`c1` tinyint(4) NOT NULL,
2290
`c2` int(11) NOT NULL,
2291
`c4` binary(5) NOT NULL,
2292
`c3` binary(10) NOT NULL,
2294
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2298
CREATE TABLE t5(c1 SMALLINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2302
SHOW CREATE TABLE t5;
2304
t5 CREATE TABLE `t5` (
2305
`c1` smallint(6) NOT NULL,
2306
`c2` int(11) NOT NULL,
2307
`c3` binary(10) NOT NULL,
2309
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2310
ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2314
SHOW CREATE TABLE t5;
2316
t5 CREATE TABLE `t5` (
2317
`c1` smallint(6) NOT NULL,
2318
`c2` int(11) NOT NULL,
2319
`c4` binary(5) NOT NULL,
2320
`c3` binary(10) NOT NULL,
2322
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2326
CREATE TABLE t5(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2330
SHOW CREATE TABLE t5;
2332
t5 CREATE TABLE `t5` (
2333
`c1` mediumint(9) NOT NULL,
2334
`c2` int(11) NOT NULL,
2335
`c3` binary(10) NOT NULL,
2337
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2338
ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2342
SHOW CREATE TABLE t5;
2344
t5 CREATE TABLE `t5` (
2345
`c1` mediumint(9) NOT NULL,
2346
`c2` int(11) NOT NULL,
2347
`c4` binary(5) NOT NULL,
2348
`c3` binary(10) NOT NULL,
2350
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2354
CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2358
SHOW CREATE TABLE t5;
2360
t5 CREATE TABLE `t5` (
2361
`c1` int(11) NOT NULL,
2362
`c2` int(11) NOT NULL,
2363
`c3` binary(10) NOT NULL,
2365
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2366
ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2370
SHOW CREATE TABLE t5;
2372
t5 CREATE TABLE `t5` (
2373
`c1` int(11) NOT NULL,
2374
`c2` int(11) NOT NULL,
2375
`c4` binary(5) NOT NULL,
2376
`c3` binary(10) NOT NULL,
2378
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2382
CREATE TABLE t5(c1 INTEGER NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2386
SHOW CREATE TABLE t5;
2388
t5 CREATE TABLE `t5` (
2389
`c1` int(11) NOT NULL,
2390
`c2` int(11) NOT NULL,
2391
`c3` binary(10) NOT NULL,
2393
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2394
ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2398
SHOW CREATE TABLE t5;
2400
t5 CREATE TABLE `t5` (
2401
`c1` int(11) NOT NULL,
2402
`c2` int(11) NOT NULL,
2403
`c4` binary(5) NOT NULL,
2404
`c3` binary(10) NOT NULL,
2406
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2410
CREATE TABLE t5(c1 BIGINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2414
SHOW CREATE TABLE t5;
2416
t5 CREATE TABLE `t5` (
2417
`c1` bigint(20) NOT NULL,
2418
`c2` int(11) NOT NULL,
2419
`c3` binary(10) NOT NULL,
2421
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2422
ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2426
SHOW CREATE TABLE t5;
2428
t5 CREATE TABLE `t5` (
2429
`c1` bigint(20) NOT NULL,
2430
`c2` int(11) NOT NULL,
2431
`c4` binary(5) NOT NULL,
2432
`c3` binary(10) NOT NULL,
2434
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2438
CREATE TABLE t5(c1 REAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2442
SHOW CREATE TABLE t5;
2444
t5 CREATE TABLE `t5` (
2445
`c1` double NOT NULL,
2446
`c2` int(11) NOT NULL,
2447
`c3` binary(10) NOT NULL,
2449
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2450
ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2454
SHOW CREATE TABLE t5;
2456
t5 CREATE TABLE `t5` (
2457
`c1` double NOT NULL,
2458
`c2` int(11) NOT NULL,
2459
`c4` binary(5) NOT NULL,
2460
`c3` binary(10) NOT NULL,
2462
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2466
CREATE TABLE t5(c1 DOUBLE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2470
SHOW CREATE TABLE t5;
2472
t5 CREATE TABLE `t5` (
2473
`c1` double NOT NULL,
2474
`c2` int(11) NOT NULL,
2475
`c3` binary(10) NOT NULL,
2477
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2478
ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2482
SHOW CREATE TABLE t5;
2484
t5 CREATE TABLE `t5` (
2485
`c1` double NOT NULL,
2486
`c2` int(11) NOT NULL,
2487
`c4` binary(5) NOT NULL,
2488
`c3` binary(10) NOT NULL,
2490
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2494
CREATE TABLE t5(c1 FLOAT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2498
SHOW CREATE TABLE t5;
2500
t5 CREATE TABLE `t5` (
2501
`c1` float NOT NULL,
2502
`c2` int(11) NOT NULL,
2503
`c3` binary(10) NOT NULL,
2505
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2506
ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2510
SHOW CREATE TABLE t5;
2512
t5 CREATE TABLE `t5` (
2513
`c1` float NOT NULL,
2514
`c2` int(11) NOT NULL,
2515
`c4` binary(5) NOT NULL,
2516
`c3` binary(10) NOT NULL,
2518
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2522
CREATE TABLE t5(c1 DECIMAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2526
SHOW CREATE TABLE t5;
2528
t5 CREATE TABLE `t5` (
2529
`c1` decimal(10,0) NOT NULL,
2530
`c2` int(11) NOT NULL,
2531
`c3` binary(10) NOT NULL,
2533
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2534
ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2538
SHOW CREATE TABLE t5;
2540
t5 CREATE TABLE `t5` (
2541
`c1` decimal(10,0) NOT NULL,
2542
`c2` int(11) NOT NULL,
2543
`c4` binary(5) NOT NULL,
2544
`c3` binary(10) NOT NULL,
2546
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2550
CREATE TABLE t5(c1 NUMERIC NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2554
SHOW CREATE TABLE t5;
2556
t5 CREATE TABLE `t5` (
2557
`c1` decimal(10,0) NOT NULL,
2558
`c2` int(11) NOT NULL,
2559
`c3` binary(10) NOT NULL,
2561
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2562
ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2566
SHOW CREATE TABLE t5;
2568
t5 CREATE TABLE `t5` (
2569
`c1` decimal(10,0) NOT NULL,
2570
`c2` int(11) NOT NULL,
2571
`c4` binary(5) NOT NULL,
2572
`c3` binary(10) NOT NULL,
2574
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2578
CREATE TABLE t5(c1 DATE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2582
SHOW CREATE TABLE t5;
2584
t5 CREATE TABLE `t5` (
2586
`c2` int(11) NOT NULL,
2587
`c3` binary(10) NOT NULL,
2589
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2590
ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2594
SHOW CREATE TABLE t5;
2596
t5 CREATE TABLE `t5` (
2598
`c2` int(11) NOT NULL,
2599
`c4` binary(5) NOT NULL,
2600
`c3` binary(10) NOT NULL,
2602
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2606
CREATE TABLE t5(c1 TIME NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2610
SHOW CREATE TABLE t5;
2612
t5 CREATE TABLE `t5` (
2614
`c2` int(11) NOT NULL,
2615
`c3` binary(10) NOT NULL,
2617
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2618
ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2622
SHOW CREATE TABLE t5;
2624
t5 CREATE TABLE `t5` (
2626
`c2` int(11) NOT NULL,
2627
`c4` binary(5) NOT NULL,
2628
`c3` binary(10) NOT NULL,
2630
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2634
CREATE TABLE t5(c1 TIMESTAMP NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2638
SHOW CREATE TABLE t5;
2640
t5 CREATE TABLE `t5` (
2641
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2642
`c2` int(11) NOT NULL,
2643
`c3` binary(10) NOT NULL,
2645
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2646
ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2650
SHOW CREATE TABLE t5;
2652
t5 CREATE TABLE `t5` (
2653
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2654
`c2` int(11) NOT NULL,
2655
`c4` binary(5) NOT NULL,
2656
`c3` binary(10) NOT NULL,
2658
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2662
CREATE TABLE t5(c1 YEAR NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(10) NOT NULL);
2666
SHOW CREATE TABLE t5;
2668
t5 CREATE TABLE `t5` (
2669
`c1` year(4) NOT NULL,
2670
`c2` int(11) NOT NULL,
2671
`c3` binary(10) NOT NULL,
2673
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2674
ALTER TABLE t5 ADD c4 BINARY(5) NOT NULL AFTER c2;
2678
SHOW CREATE TABLE t5;
2680
t5 CREATE TABLE `t5` (
2681
`c1` year(4) NOT NULL,
2682
`c2` int(11) NOT NULL,
2683
`c4` binary(5) NOT NULL,
2684
`c3` binary(10) NOT NULL,
2686
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2690
CREATE TABLE t5(c1 BIT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2694
SHOW CREATE TABLE t5;
2696
t5 CREATE TABLE `t5` (
2697
`c1` bit(1) NOT NULL,
2698
`c2` int(11) NOT NULL,
2699
`c3` varbinary(10) DEFAULT NULL,
2701
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2702
ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2706
SHOW CREATE TABLE t5;
2708
t5 CREATE TABLE `t5` (
2709
`c1` bit(1) NOT NULL,
2710
`c2` int(11) NOT NULL,
2711
`c4` varbinary(5) DEFAULT NULL,
2712
`c3` varbinary(10) DEFAULT NULL,
2714
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2718
CREATE TABLE t5(c1 TINYINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2722
SHOW CREATE TABLE t5;
2724
t5 CREATE TABLE `t5` (
2725
`c1` tinyint(4) NOT NULL,
2726
`c2` int(11) NOT NULL,
2727
`c3` varbinary(10) DEFAULT NULL,
2729
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2730
ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2734
SHOW CREATE TABLE t5;
2736
t5 CREATE TABLE `t5` (
2737
`c1` tinyint(4) NOT NULL,
2738
`c2` int(11) NOT NULL,
2739
`c4` varbinary(5) DEFAULT NULL,
2740
`c3` varbinary(10) DEFAULT NULL,
2742
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2746
CREATE TABLE t5(c1 SMALLINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2750
SHOW CREATE TABLE t5;
2752
t5 CREATE TABLE `t5` (
2753
`c1` smallint(6) NOT NULL,
2754
`c2` int(11) NOT NULL,
2755
`c3` varbinary(10) DEFAULT NULL,
2757
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2758
ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2762
SHOW CREATE TABLE t5;
2764
t5 CREATE TABLE `t5` (
2765
`c1` smallint(6) NOT NULL,
2766
`c2` int(11) NOT NULL,
2767
`c4` varbinary(5) DEFAULT NULL,
2768
`c3` varbinary(10) DEFAULT NULL,
2770
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2774
CREATE TABLE t5(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2778
SHOW CREATE TABLE t5;
2780
t5 CREATE TABLE `t5` (
2781
`c1` mediumint(9) NOT NULL,
2782
`c2` int(11) NOT NULL,
2783
`c3` varbinary(10) DEFAULT NULL,
2785
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2786
ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2790
SHOW CREATE TABLE t5;
2792
t5 CREATE TABLE `t5` (
2793
`c1` mediumint(9) NOT NULL,
2794
`c2` int(11) NOT NULL,
2795
`c4` varbinary(5) DEFAULT NULL,
2796
`c3` varbinary(10) DEFAULT NULL,
2798
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2802
CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2806
SHOW CREATE TABLE t5;
2808
t5 CREATE TABLE `t5` (
2809
`c1` int(11) NOT NULL,
2810
`c2` int(11) NOT NULL,
2811
`c3` varbinary(10) DEFAULT NULL,
2813
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2814
ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2818
SHOW CREATE TABLE t5;
2820
t5 CREATE TABLE `t5` (
2821
`c1` int(11) NOT NULL,
2822
`c2` int(11) NOT NULL,
2823
`c4` varbinary(5) DEFAULT NULL,
2824
`c3` varbinary(10) DEFAULT NULL,
2826
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2830
CREATE TABLE t5(c1 INTEGER NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2834
SHOW CREATE TABLE t5;
2836
t5 CREATE TABLE `t5` (
2837
`c1` int(11) NOT NULL,
2838
`c2` int(11) NOT NULL,
2839
`c3` varbinary(10) DEFAULT NULL,
2841
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2842
ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2846
SHOW CREATE TABLE t5;
2848
t5 CREATE TABLE `t5` (
2849
`c1` int(11) NOT NULL,
2850
`c2` int(11) NOT NULL,
2851
`c4` varbinary(5) DEFAULT NULL,
2852
`c3` varbinary(10) DEFAULT NULL,
2854
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2858
CREATE TABLE t5(c1 BIGINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2862
SHOW CREATE TABLE t5;
2864
t5 CREATE TABLE `t5` (
2865
`c1` bigint(20) NOT NULL,
2866
`c2` int(11) NOT NULL,
2867
`c3` varbinary(10) DEFAULT NULL,
2869
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2870
ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2874
SHOW CREATE TABLE t5;
2876
t5 CREATE TABLE `t5` (
2877
`c1` bigint(20) NOT NULL,
2878
`c2` int(11) NOT NULL,
2879
`c4` varbinary(5) DEFAULT NULL,
2880
`c3` varbinary(10) DEFAULT NULL,
2882
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2886
CREATE TABLE t5(c1 REAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2890
SHOW CREATE TABLE t5;
2892
t5 CREATE TABLE `t5` (
2893
`c1` double NOT NULL,
2894
`c2` int(11) NOT NULL,
2895
`c3` varbinary(10) DEFAULT NULL,
2897
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2898
ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2902
SHOW CREATE TABLE t5;
2904
t5 CREATE TABLE `t5` (
2905
`c1` double NOT NULL,
2906
`c2` int(11) NOT NULL,
2907
`c4` varbinary(5) DEFAULT NULL,
2908
`c3` varbinary(10) DEFAULT NULL,
2910
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2914
CREATE TABLE t5(c1 DOUBLE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2918
SHOW CREATE TABLE t5;
2920
t5 CREATE TABLE `t5` (
2921
`c1` double NOT NULL,
2922
`c2` int(11) NOT NULL,
2923
`c3` varbinary(10) DEFAULT NULL,
2925
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2926
ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2930
SHOW CREATE TABLE t5;
2932
t5 CREATE TABLE `t5` (
2933
`c1` double NOT NULL,
2934
`c2` int(11) NOT NULL,
2935
`c4` varbinary(5) DEFAULT NULL,
2936
`c3` varbinary(10) DEFAULT NULL,
2938
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2942
CREATE TABLE t5(c1 FLOAT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2946
SHOW CREATE TABLE t5;
2948
t5 CREATE TABLE `t5` (
2949
`c1` float NOT NULL,
2950
`c2` int(11) NOT NULL,
2951
`c3` varbinary(10) DEFAULT NULL,
2953
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2954
ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2958
SHOW CREATE TABLE t5;
2960
t5 CREATE TABLE `t5` (
2961
`c1` float NOT NULL,
2962
`c2` int(11) NOT NULL,
2963
`c4` varbinary(5) DEFAULT NULL,
2964
`c3` varbinary(10) DEFAULT NULL,
2966
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2970
CREATE TABLE t5(c1 DECIMAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
2974
SHOW CREATE TABLE t5;
2976
t5 CREATE TABLE `t5` (
2977
`c1` decimal(10,0) NOT NULL,
2978
`c2` int(11) NOT NULL,
2979
`c3` varbinary(10) DEFAULT NULL,
2981
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2982
ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
2986
SHOW CREATE TABLE t5;
2988
t5 CREATE TABLE `t5` (
2989
`c1` decimal(10,0) NOT NULL,
2990
`c2` int(11) NOT NULL,
2991
`c4` varbinary(5) DEFAULT NULL,
2992
`c3` varbinary(10) DEFAULT NULL,
2994
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2998
CREATE TABLE t5(c1 NUMERIC NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
3002
SHOW CREATE TABLE t5;
3004
t5 CREATE TABLE `t5` (
3005
`c1` decimal(10,0) NOT NULL,
3006
`c2` int(11) NOT NULL,
3007
`c3` varbinary(10) DEFAULT NULL,
3009
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3010
ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
3014
SHOW CREATE TABLE t5;
3016
t5 CREATE TABLE `t5` (
3017
`c1` decimal(10,0) NOT NULL,
3018
`c2` int(11) NOT NULL,
3019
`c4` varbinary(5) DEFAULT NULL,
3020
`c3` varbinary(10) DEFAULT NULL,
3022
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3026
CREATE TABLE t5(c1 DATE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
3030
SHOW CREATE TABLE t5;
3032
t5 CREATE TABLE `t5` (
3034
`c2` int(11) NOT NULL,
3035
`c3` varbinary(10) DEFAULT NULL,
3037
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3038
ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
3042
SHOW CREATE TABLE t5;
3044
t5 CREATE TABLE `t5` (
3046
`c2` int(11) NOT NULL,
3047
`c4` varbinary(5) DEFAULT NULL,
3048
`c3` varbinary(10) DEFAULT NULL,
3050
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3054
CREATE TABLE t5(c1 TIME NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
3058
SHOW CREATE TABLE t5;
3060
t5 CREATE TABLE `t5` (
3062
`c2` int(11) NOT NULL,
3063
`c3` varbinary(10) DEFAULT NULL,
3065
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3066
ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
3070
SHOW CREATE TABLE t5;
3072
t5 CREATE TABLE `t5` (
3074
`c2` int(11) NOT NULL,
3075
`c4` varbinary(5) DEFAULT NULL,
3076
`c3` varbinary(10) DEFAULT NULL,
3078
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3082
CREATE TABLE t5(c1 TIMESTAMP NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
3086
SHOW CREATE TABLE t5;
3088
t5 CREATE TABLE `t5` (
3089
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3090
`c2` int(11) NOT NULL,
3091
`c3` varbinary(10) DEFAULT NULL,
3093
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3094
ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
3098
SHOW CREATE TABLE t5;
3100
t5 CREATE TABLE `t5` (
3101
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3102
`c2` int(11) NOT NULL,
3103
`c4` varbinary(5) DEFAULT NULL,
3104
`c3` varbinary(10) DEFAULT NULL,
3106
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3110
CREATE TABLE t5(c1 YEAR NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NULL);
3114
SHOW CREATE TABLE t5;
3116
t5 CREATE TABLE `t5` (
3117
`c1` year(4) NOT NULL,
3118
`c2` int(11) NOT NULL,
3119
`c3` varbinary(10) DEFAULT NULL,
3121
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3122
ALTER TABLE t5 ADD c4 VARBINARY(5) NULL AFTER c2;
3126
SHOW CREATE TABLE t5;
3128
t5 CREATE TABLE `t5` (
3129
`c1` year(4) NOT NULL,
3130
`c2` int(11) NOT NULL,
3131
`c4` varbinary(5) DEFAULT NULL,
3132
`c3` varbinary(10) DEFAULT NULL,
3134
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3138
CREATE TABLE t5(c1 BIT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3142
SHOW CREATE TABLE t5;
3144
t5 CREATE TABLE `t5` (
3145
`c1` bit(1) NOT NULL,
3146
`c2` int(11) NOT NULL,
3147
`c3` varbinary(10) NOT NULL,
3149
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3150
ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3154
SHOW CREATE TABLE t5;
3156
t5 CREATE TABLE `t5` (
3157
`c1` bit(1) NOT NULL,
3158
`c2` int(11) NOT NULL,
3159
`c4` varbinary(5) NOT NULL,
3160
`c3` varbinary(10) NOT NULL,
3162
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3166
CREATE TABLE t5(c1 TINYINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3170
SHOW CREATE TABLE t5;
3172
t5 CREATE TABLE `t5` (
3173
`c1` tinyint(4) NOT NULL,
3174
`c2` int(11) NOT NULL,
3175
`c3` varbinary(10) NOT NULL,
3177
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3178
ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3182
SHOW CREATE TABLE t5;
3184
t5 CREATE TABLE `t5` (
3185
`c1` tinyint(4) NOT NULL,
3186
`c2` int(11) NOT NULL,
3187
`c4` varbinary(5) NOT NULL,
3188
`c3` varbinary(10) NOT NULL,
3190
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3194
CREATE TABLE t5(c1 SMALLINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3198
SHOW CREATE TABLE t5;
3200
t5 CREATE TABLE `t5` (
3201
`c1` smallint(6) NOT NULL,
3202
`c2` int(11) NOT NULL,
3203
`c3` varbinary(10) NOT NULL,
3205
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3206
ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3210
SHOW CREATE TABLE t5;
3212
t5 CREATE TABLE `t5` (
3213
`c1` smallint(6) NOT NULL,
3214
`c2` int(11) NOT NULL,
3215
`c4` varbinary(5) NOT NULL,
3216
`c3` varbinary(10) NOT NULL,
3218
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3222
CREATE TABLE t5(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3226
SHOW CREATE TABLE t5;
3228
t5 CREATE TABLE `t5` (
3229
`c1` mediumint(9) NOT NULL,
3230
`c2` int(11) NOT NULL,
3231
`c3` varbinary(10) NOT NULL,
3233
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3234
ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3238
SHOW CREATE TABLE t5;
3240
t5 CREATE TABLE `t5` (
3241
`c1` mediumint(9) NOT NULL,
3242
`c2` int(11) NOT NULL,
3243
`c4` varbinary(5) NOT NULL,
3244
`c3` varbinary(10) NOT NULL,
3246
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3250
CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3254
SHOW CREATE TABLE t5;
3256
t5 CREATE TABLE `t5` (
3257
`c1` int(11) NOT NULL,
3258
`c2` int(11) NOT NULL,
3259
`c3` varbinary(10) NOT NULL,
3261
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3262
ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3266
SHOW CREATE TABLE t5;
3268
t5 CREATE TABLE `t5` (
3269
`c1` int(11) NOT NULL,
3270
`c2` int(11) NOT NULL,
3271
`c4` varbinary(5) NOT NULL,
3272
`c3` varbinary(10) NOT NULL,
3274
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3278
CREATE TABLE t5(c1 INTEGER NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3282
SHOW CREATE TABLE t5;
3284
t5 CREATE TABLE `t5` (
3285
`c1` int(11) NOT NULL,
3286
`c2` int(11) NOT NULL,
3287
`c3` varbinary(10) NOT NULL,
3289
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3290
ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3294
SHOW CREATE TABLE t5;
3296
t5 CREATE TABLE `t5` (
3297
`c1` int(11) NOT NULL,
3298
`c2` int(11) NOT NULL,
3299
`c4` varbinary(5) NOT NULL,
3300
`c3` varbinary(10) NOT NULL,
3302
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3306
CREATE TABLE t5(c1 BIGINT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3310
SHOW CREATE TABLE t5;
3312
t5 CREATE TABLE `t5` (
3313
`c1` bigint(20) NOT NULL,
3314
`c2` int(11) NOT NULL,
3315
`c3` varbinary(10) NOT NULL,
3317
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3318
ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3322
SHOW CREATE TABLE t5;
3324
t5 CREATE TABLE `t5` (
3325
`c1` bigint(20) NOT NULL,
3326
`c2` int(11) NOT NULL,
3327
`c4` varbinary(5) NOT NULL,
3328
`c3` varbinary(10) NOT NULL,
3330
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3334
CREATE TABLE t5(c1 REAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3338
SHOW CREATE TABLE t5;
3340
t5 CREATE TABLE `t5` (
3341
`c1` double NOT NULL,
3342
`c2` int(11) NOT NULL,
3343
`c3` varbinary(10) NOT NULL,
3345
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3346
ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3350
SHOW CREATE TABLE t5;
3352
t5 CREATE TABLE `t5` (
3353
`c1` double NOT NULL,
3354
`c2` int(11) NOT NULL,
3355
`c4` varbinary(5) NOT NULL,
3356
`c3` varbinary(10) NOT NULL,
3358
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3362
CREATE TABLE t5(c1 DOUBLE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3366
SHOW CREATE TABLE t5;
3368
t5 CREATE TABLE `t5` (
3369
`c1` double NOT NULL,
3370
`c2` int(11) NOT NULL,
3371
`c3` varbinary(10) NOT NULL,
3373
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3374
ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3378
SHOW CREATE TABLE t5;
3380
t5 CREATE TABLE `t5` (
3381
`c1` double NOT NULL,
3382
`c2` int(11) NOT NULL,
3383
`c4` varbinary(5) NOT NULL,
3384
`c3` varbinary(10) NOT NULL,
3386
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3390
CREATE TABLE t5(c1 FLOAT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3394
SHOW CREATE TABLE t5;
3396
t5 CREATE TABLE `t5` (
3397
`c1` float NOT NULL,
3398
`c2` int(11) NOT NULL,
3399
`c3` varbinary(10) NOT NULL,
3401
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3402
ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3406
SHOW CREATE TABLE t5;
3408
t5 CREATE TABLE `t5` (
3409
`c1` float NOT NULL,
3410
`c2` int(11) NOT NULL,
3411
`c4` varbinary(5) NOT NULL,
3412
`c3` varbinary(10) NOT NULL,
3414
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3418
CREATE TABLE t5(c1 DECIMAL NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3422
SHOW CREATE TABLE t5;
3424
t5 CREATE TABLE `t5` (
3425
`c1` decimal(10,0) NOT NULL,
3426
`c2` int(11) NOT NULL,
3427
`c3` varbinary(10) NOT NULL,
3429
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3430
ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3434
SHOW CREATE TABLE t5;
3436
t5 CREATE TABLE `t5` (
3437
`c1` decimal(10,0) NOT NULL,
3438
`c2` int(11) NOT NULL,
3439
`c4` varbinary(5) NOT NULL,
3440
`c3` varbinary(10) NOT NULL,
3442
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3446
CREATE TABLE t5(c1 NUMERIC NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3450
SHOW CREATE TABLE t5;
3452
t5 CREATE TABLE `t5` (
3453
`c1` decimal(10,0) NOT NULL,
3454
`c2` int(11) NOT NULL,
3455
`c3` varbinary(10) NOT NULL,
3457
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3458
ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3462
SHOW CREATE TABLE t5;
3464
t5 CREATE TABLE `t5` (
3465
`c1` decimal(10,0) NOT NULL,
3466
`c2` int(11) NOT NULL,
3467
`c4` varbinary(5) NOT NULL,
3468
`c3` varbinary(10) NOT NULL,
3470
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3474
CREATE TABLE t5(c1 DATE NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3478
SHOW CREATE TABLE t5;
3480
t5 CREATE TABLE `t5` (
3482
`c2` int(11) NOT NULL,
3483
`c3` varbinary(10) NOT NULL,
3485
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3486
ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3490
SHOW CREATE TABLE t5;
3492
t5 CREATE TABLE `t5` (
3494
`c2` int(11) NOT NULL,
3495
`c4` varbinary(5) NOT NULL,
3496
`c3` varbinary(10) NOT NULL,
3498
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3502
CREATE TABLE t5(c1 TIME NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3506
SHOW CREATE TABLE t5;
3508
t5 CREATE TABLE `t5` (
3510
`c2` int(11) NOT NULL,
3511
`c3` varbinary(10) NOT NULL,
3513
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3514
ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3518
SHOW CREATE TABLE t5;
3520
t5 CREATE TABLE `t5` (
3522
`c2` int(11) NOT NULL,
3523
`c4` varbinary(5) NOT NULL,
3524
`c3` varbinary(10) NOT NULL,
3526
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3530
CREATE TABLE t5(c1 TIMESTAMP NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3534
SHOW CREATE TABLE t5;
3536
t5 CREATE TABLE `t5` (
3537
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3538
`c2` int(11) NOT NULL,
3539
`c3` varbinary(10) NOT NULL,
3541
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3542
ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3546
SHOW CREATE TABLE t5;
3548
t5 CREATE TABLE `t5` (
3549
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3550
`c2` int(11) NOT NULL,
3551
`c4` varbinary(5) NOT NULL,
3552
`c3` varbinary(10) NOT NULL,
3554
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3558
CREATE TABLE t5(c1 YEAR NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(10) NOT NULL);
3562
SHOW CREATE TABLE t5;
3564
t5 CREATE TABLE `t5` (
3565
`c1` year(4) NOT NULL,
3566
`c2` int(11) NOT NULL,
3567
`c3` varbinary(10) NOT NULL,
3569
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3570
ALTER TABLE t5 ADD c4 VARBINARY(5) NOT NULL AFTER c2;
3574
SHOW CREATE TABLE t5;
3576
t5 CREATE TABLE `t5` (
3577
`c1` year(4) NOT NULL,
3578
`c2` int(11) NOT NULL,
3579
`c4` varbinary(5) NOT NULL,
3580
`c3` varbinary(10) NOT NULL,
3582
) ENGINE=ENGINE DEFAULT CHARSET=latin1