9
9
col6 int not null, to_be_deleted int);
10
10
insert into t1 values (2,4,3,5,"PENDING",1,7);
15
15
change column col2 fourth varchar(30) not null after col3,
16
16
modify column col6 int not null first;
18
18
col6 col1 col3 fourth col4 col4_5 col5 col7 col8
21
21
create table t1 (bandID INT NOT NULL PRIMARY KEY, payoutID int NOT NULL);
22
22
insert into t1 (bandID,payoutID) VALUES (1,6),(2,6),(3,4),(4,9),(5,10),(6,1),(7,12),(8,12);