2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
8
CREATE TABLE t1 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
10
f5 FLOAT DEFAULT '2.00',
11
f6 CHAR(4) DEFAULT 'TEST',
18
alter table t1 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11;
19
INSERT into t1 values (1, 1, 1, 'first', 1.0, 'yksi', 1, 'lounge of happiness', 'very fat blob', b'01010101010101', 0x123456);
20
INSERT into t1 values (2, 2, 2, 'second', 2.0, 'kaks', 2, 'got stolen from the paradise', 'very fat blob', b'01010101010101', 0x123456), (3, 3, 3, 'third', 3.0, 'kolm', 3, 'got stolen from the paradise', 'very fat blob', b'01010101010101', 0x123456);
21
update t1 set f4= 'next' where f1=1;
22
delete from t1 where f1=1;
23
select * from t1 order by f3;
24
f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11
25
2 2 2 second 2 kaks 2 got stolen from the paradise very fat blob