1drop table if exists t1; 2CREATE LOGFILE GROUP lg1 3ADD UNDOFILE 'undofile.dat' 4INITIAL_SIZE 1M 5UNDO_BUFFER_SIZE = 1M 6ENGINE=NDB; 7CREATE TABLESPACE ts1 8ADD DATAFILE 'datafile.dat' 9USE LOGFILE GROUP lg1 10INITIAL_SIZE 6M 11ENGINE NDB; 12create table t1 (a int column_format DYNAMIC STORAGE DISK) TABLESPACE ts1 engine NDB; 13Warnings: 14Warning 1478 DYNAMIC column a with STORAGE DISK is not supported, column will become FIXED 15show create table t1; 16Table Create Table 17t1 CREATE TABLE `t1` ( 18 `a` int(11) /*!50120 STORAGE DISK */ /*!50120 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL 19) /*!50100 TABLESPACE ts1 */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 20Attributes: 21a Int NULL AT=FIXED ST=DISK 22$PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR 23drop table t1; 24create table t1 (a int column_format DYNAMIC, 25a1 int column_format FIXED, 26b int NOT NULL column_format DYNAMIC, 27b1 int NOT NULL column_format FIXED storage DISK, 28c VARCHAR(100) column_format FIXED, 29c1 VARCHAR(100) column_format DYNAMIC storage memory, 30d VARCHAR(100) NOT NULL column_format FIXED, 31d1 VARCHAR(100) NOT NULL column_format DYNAMIC, 32e CHAR(100) column_format FIXED, 33e1 CHAR(100) column_format DYNAMIC, 34f CHAR(100) NOT NULL column_format FIXED, 35f1 char(100) NOT NULL column_format DYNAMIC storage DISK, 36index (b)) TABLESPACE ts1 engine NDB; 37Warnings: 38Warning 1478 DYNAMIC column f1 with STORAGE DISK is not supported, column will become FIXED 39insert into t1 (b, b1, d,d1,f,f1) values 40(1,1,"1","1","1","1"), 41(2,2,"2","2","2","2"), 42(3,3,"3","3","3","3"); 43alter table t1 change column a a int column_format FIXED; 44Warnings: 45Warning 1478 DYNAMIC column f1 with STORAGE DISK is not supported, column will become FIXED 46show create table t1; 47Table Create Table 48t1 CREATE TABLE `t1` ( 49 `a` int(11) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 50 `a1` int(11) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 51 `b` int(11) NOT NULL /*!50120 COLUMN_FORMAT DYNAMIC */, 52 `b1` int(11) NOT NULL /*!50120 STORAGE DISK */ /*!50120 COLUMN_FORMAT FIXED */, 53 `c` varchar(100) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 54 `c1` varchar(100) /*!50120 STORAGE MEMORY */ /*!50120 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL, 55 `d` varchar(100) NOT NULL /*!50120 COLUMN_FORMAT FIXED */, 56 `d1` varchar(100) NOT NULL /*!50120 COLUMN_FORMAT DYNAMIC */, 57 `e` char(100) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 58 `e1` char(100) /*!50120 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL, 59 `f` char(100) NOT NULL /*!50120 COLUMN_FORMAT FIXED */, 60 `f1` char(100) NOT NULL /*!50120 STORAGE DISK */ /*!50120 COLUMN_FORMAT DYNAMIC */, 61 KEY `b` (`b`) 62) /*!50100 TABLESPACE ts1 */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 63alter table t1 change column a a int storage disk; 64Warnings: 65Warning 1478 DYNAMIC column f1 with STORAGE DISK is not supported, column will become FIXED 66show create table t1; 67Table Create Table 68t1 CREATE TABLE `t1` ( 69 `a` int(11) /*!50120 STORAGE DISK */ DEFAULT NULL, 70 `a1` int(11) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 71 `b` int(11) NOT NULL /*!50120 COLUMN_FORMAT DYNAMIC */, 72 `b1` int(11) NOT NULL /*!50120 STORAGE DISK */ /*!50120 COLUMN_FORMAT FIXED */, 73 `c` varchar(100) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 74 `c1` varchar(100) /*!50120 STORAGE MEMORY */ /*!50120 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL, 75 `d` varchar(100) NOT NULL /*!50120 COLUMN_FORMAT FIXED */, 76 `d1` varchar(100) NOT NULL /*!50120 COLUMN_FORMAT DYNAMIC */, 77 `e` char(100) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 78 `e1` char(100) /*!50120 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL, 79 `f` char(100) NOT NULL /*!50120 COLUMN_FORMAT FIXED */, 80 `f1` char(100) NOT NULL /*!50120 STORAGE DISK */ /*!50120 COLUMN_FORMAT DYNAMIC */, 81 KEY `b` (`b`) 82) /*!50100 TABLESPACE ts1 */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 83Attributes: 84a Int NULL AT=FIXED ST=DISK 85a1 Int NULL AT=FIXED ST=MEMORY 86b Int NOT NULL AT=FIXED ST=MEMORY DYNAMIC 87b1 Int NOT NULL AT=FIXED ST=DISK 88c Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY 89c1 Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY DYNAMIC 90d Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY 91d1 Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY DYNAMIC 92e Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY 93e1 Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY DYNAMIC 94f Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=MEMORY 95f1 Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=DISK 96$PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR 97alter table t1 change column a a int storage memory; 98Warnings: 99Warning 1478 DYNAMIC column f1 with STORAGE DISK is not supported, column will become FIXED 100show create table t1; 101Table Create Table 102t1 CREATE TABLE `t1` ( 103 `a` int(11) /*!50120 STORAGE MEMORY */ DEFAULT NULL, 104 `a1` int(11) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 105 `b` int(11) NOT NULL /*!50120 COLUMN_FORMAT DYNAMIC */, 106 `b1` int(11) NOT NULL /*!50120 STORAGE DISK */ /*!50120 COLUMN_FORMAT FIXED */, 107 `c` varchar(100) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 108 `c1` varchar(100) /*!50120 STORAGE MEMORY */ /*!50120 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL, 109 `d` varchar(100) NOT NULL /*!50120 COLUMN_FORMAT FIXED */, 110 `d1` varchar(100) NOT NULL /*!50120 COLUMN_FORMAT DYNAMIC */, 111 `e` char(100) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 112 `e1` char(100) /*!50120 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL, 113 `f` char(100) NOT NULL /*!50120 COLUMN_FORMAT FIXED */, 114 `f1` char(100) NOT NULL /*!50120 STORAGE DISK */ /*!50120 COLUMN_FORMAT DYNAMIC */, 115 KEY `b` (`b`) 116) /*!50100 TABLESPACE ts1 */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 117Attributes: 118a Int NULL AT=FIXED ST=MEMORY 119a1 Int NULL AT=FIXED ST=MEMORY 120b Int NOT NULL AT=FIXED ST=MEMORY DYNAMIC 121b1 Int NOT NULL AT=FIXED ST=DISK 122c Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY 123c1 Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY DYNAMIC 124d Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY 125d1 Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY DYNAMIC 126e Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY 127e1 Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY DYNAMIC 128f Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=MEMORY 129f1 Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=DISK 130$PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR 131alter table t1 change column b b int NOT NULL storage memory; 132Warnings: 133Warning 1478 DYNAMIC column f1 with STORAGE DISK is not supported, column will become FIXED 134alter table t1 add column a2 int column_format FIXED; 135Warnings: 136Warning 1478 DYNAMIC column f1 with STORAGE DISK is not supported, column will become FIXED 137show create table t1; 138Table Create Table 139t1 CREATE TABLE `t1` ( 140 `a` int(11) /*!50120 STORAGE MEMORY */ DEFAULT NULL, 141 `a1` int(11) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 142 `b` int(11) NOT NULL /*!50120 STORAGE MEMORY */, 143 `b1` int(11) NOT NULL /*!50120 STORAGE DISK */ /*!50120 COLUMN_FORMAT FIXED */, 144 `c` varchar(100) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 145 `c1` varchar(100) /*!50120 STORAGE MEMORY */ /*!50120 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL, 146 `d` varchar(100) NOT NULL /*!50120 COLUMN_FORMAT FIXED */, 147 `d1` varchar(100) NOT NULL /*!50120 COLUMN_FORMAT DYNAMIC */, 148 `e` char(100) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 149 `e1` char(100) /*!50120 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL, 150 `f` char(100) NOT NULL /*!50120 COLUMN_FORMAT FIXED */, 151 `f1` char(100) NOT NULL /*!50120 STORAGE DISK */ /*!50120 COLUMN_FORMAT DYNAMIC */, 152 `a2` int(11) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 153 KEY `b` (`b`) 154) /*!50100 TABLESPACE ts1 */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 155Attributes: 156a Int NULL AT=FIXED ST=MEMORY 157a1 Int NULL AT=FIXED ST=MEMORY 158b Int NOT NULL AT=FIXED ST=MEMORY 159b1 Int NOT NULL AT=FIXED ST=DISK 160c Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY 161c1 Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY DYNAMIC 162d Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY 163d1 Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY DYNAMIC 164e Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY 165e1 Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY DYNAMIC 166f Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=MEMORY 167f1 Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=DISK 168a2 Int NULL AT=FIXED ST=MEMORY 169$PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR 170alter table t1 add column c2 VARCHAR(100) column_format DYNAMIC; 171Warnings: 172Warning 1478 DYNAMIC column f1 with STORAGE DISK is not supported, column will become FIXED 173show create table t1; 174Table Create Table 175t1 CREATE TABLE `t1` ( 176 `a` int(11) /*!50120 STORAGE MEMORY */ DEFAULT NULL, 177 `a1` int(11) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 178 `b` int(11) NOT NULL /*!50120 STORAGE MEMORY */, 179 `b1` int(11) NOT NULL /*!50120 STORAGE DISK */ /*!50120 COLUMN_FORMAT FIXED */, 180 `c` varchar(100) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 181 `c1` varchar(100) /*!50120 STORAGE MEMORY */ /*!50120 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL, 182 `d` varchar(100) NOT NULL /*!50120 COLUMN_FORMAT FIXED */, 183 `d1` varchar(100) NOT NULL /*!50120 COLUMN_FORMAT DYNAMIC */, 184 `e` char(100) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 185 `e1` char(100) /*!50120 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL, 186 `f` char(100) NOT NULL /*!50120 COLUMN_FORMAT FIXED */, 187 `f1` char(100) NOT NULL /*!50120 STORAGE DISK */ /*!50120 COLUMN_FORMAT DYNAMIC */, 188 `a2` int(11) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 189 `c2` varchar(100) /*!50120 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL, 190 KEY `b` (`b`) 191) /*!50100 TABLESPACE ts1 */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 192Attributes: 193a Int NULL AT=FIXED ST=MEMORY 194a1 Int NULL AT=FIXED ST=MEMORY 195b Int NOT NULL AT=FIXED ST=MEMORY 196b1 Int NOT NULL AT=FIXED ST=DISK 197c Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY 198c1 Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY DYNAMIC 199d Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY 200d1 Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY DYNAMIC 201e Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY 202e1 Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY DYNAMIC 203f Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=MEMORY 204f1 Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=DISK 205a2 Int NULL AT=FIXED ST=MEMORY 206c2 Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY DYNAMIC 207$PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR 208alter table t1 add column c3 VARCHAR(100) column_format FIXED; 209Warnings: 210Warning 1478 DYNAMIC column f1 with STORAGE DISK is not supported, column will become FIXED 211show create table t1; 212Table Create Table 213t1 CREATE TABLE `t1` ( 214 `a` int(11) /*!50120 STORAGE MEMORY */ DEFAULT NULL, 215 `a1` int(11) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 216 `b` int(11) NOT NULL /*!50120 STORAGE MEMORY */, 217 `b1` int(11) NOT NULL /*!50120 STORAGE DISK */ /*!50120 COLUMN_FORMAT FIXED */, 218 `c` varchar(100) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 219 `c1` varchar(100) /*!50120 STORAGE MEMORY */ /*!50120 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL, 220 `d` varchar(100) NOT NULL /*!50120 COLUMN_FORMAT FIXED */, 221 `d1` varchar(100) NOT NULL /*!50120 COLUMN_FORMAT DYNAMIC */, 222 `e` char(100) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 223 `e1` char(100) /*!50120 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL, 224 `f` char(100) NOT NULL /*!50120 COLUMN_FORMAT FIXED */, 225 `f1` char(100) NOT NULL /*!50120 STORAGE DISK */ /*!50120 COLUMN_FORMAT DYNAMIC */, 226 `a2` int(11) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 227 `c2` varchar(100) /*!50120 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL, 228 `c3` varchar(100) /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 229 KEY `b` (`b`) 230) /*!50100 TABLESPACE ts1 */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 231Attributes: 232a Int NULL AT=FIXED ST=MEMORY 233a1 Int NULL AT=FIXED ST=MEMORY 234b Int NOT NULL AT=FIXED ST=MEMORY 235b1 Int NOT NULL AT=FIXED ST=DISK 236c Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY 237c1 Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY DYNAMIC 238d Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY 239d1 Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY DYNAMIC 240e Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY 241e1 Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY DYNAMIC 242f Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=MEMORY 243f1 Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=DISK 244a2 Int NULL AT=FIXED ST=MEMORY 245c2 Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY DYNAMIC 246c3 Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY 247$PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR 248drop table t1; 249create table t1 (a int storage disk column_format FIXED) TABLESPACE ts1 engine NDB; 250alter table t1 change column a a int storage memory column_format DYNAMIC; 251show create table t1; 252Table Create Table 253t1 CREATE TABLE `t1` ( 254 `a` int(11) /*!50120 STORAGE MEMORY */ /*!50120 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL 255) /*!50100 TABLESPACE ts1 */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 256Attributes: 257a Int NULL AT=FIXED ST=MEMORY DYNAMIC 258$PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR 259drop table t1; 260create table t1 (column_format int storage disk column_format FIXED, storage int storage disk column_format FIXED) TABLESPACE ts1 engine NDB; 261show create table t1; 262Table Create Table 263t1 CREATE TABLE `t1` ( 264 `column_format` int(11) /*!50120 STORAGE DISK */ /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL, 265 `storage` int(11) /*!50120 STORAGE DISK */ /*!50120 COLUMN_FORMAT FIXED */ DEFAULT NULL 266) /*!50100 TABLESPACE ts1 */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 267Attributes: 268column_format Int NULL AT=FIXED ST=DISK 269storage Int NULL AT=FIXED ST=DISK 270$PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR 271drop table t1; 272ALTER TABLESPACE ts1 273DROP DATAFILE 'datafile.dat' 274ENGINE NDB; 275drop tablespace ts1 276engine ndb; 277drop logfile group lg1 278engine ndb; 279CREATE TABLE t1 ( 280pk1 INT NOT NULL auto_increment, 281c00 int not null column_format dynamic, 282c01 int not null column_format dynamic, 283c02 int not null column_format dynamic, 284c03 int not null column_format dynamic, 285c04 int not null column_format dynamic, 286c05 int not null column_format dynamic, 287c06 int not null column_format dynamic, 288c07 int not null column_format dynamic, 289c08 int not null column_format dynamic, 290c09 int not null column_format dynamic, 291c10 int not null column_format dynamic, 292c11 int not null column_format dynamic, 293c12 int not null column_format dynamic, 294c13 int not null column_format dynamic, 295c14 int not null column_format dynamic, 296c15 int not null column_format dynamic, 297c16 int not null column_format dynamic, 298c17 int not null column_format dynamic, 299c18 int not null column_format dynamic, 300c19 int not null column_format dynamic, 301primary key(pk1) 302) ENGINE=ndbcluster; 303insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21); 304insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21); 305insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21); 306insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21); 307insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21); 308insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21); 309insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21); 310insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21); 311insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21); 312insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21); 313select * from t1 order by 1; 314pk1 c00 c01 c02 c03 c04 c05 c06 c07 c08 c09 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19 3151 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 3162 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 3173 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 3184 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 3195 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 3206 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 3217 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 3228 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 3239 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 32410 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 325delete from t1; 326drop table t1; 327