1 echo create table t1 (f1 int,f2 int);
2 create table t1 (f1 int,f2 int);
3 echo check for SET AUTOCOMMIT OFF;
5 echo insert some record;
6 insert into t1 values(10,20);
7 insert into t1 values(20,30);
8 insert into t1 values(30,40);
9 insert into t1 values(40,50);
10 insert into t1 values(50,60);
13 echo select * from t1;
17 insert into t1 values(30,40);
18 insert into t1 values(30,40);
19 insert into t1 values(30,40);
20 insert into t1 values(30,40);
21 insert into t1 values(30,40);
22 insert into t1 values(30,40);
23 insert into t1 values(30,40);
24 insert into t1 values(30,40);
25 insert into t1 values(30,40);
26 insert into t1 values(30,40);
32 echo test for rollback;
33 echo insert 5 records;
35 insert into t1 values(20,40);
36 insert into t1 values(20,40);
37 insert into t1 values(20,40);
38 insert into t1 values(20,40);
39 insert into t1 values(20,40);
44 echo check for show tables;
47 echo check for SET AUTOCOMMIT ON;
50 echo insert some records;
52 insert into t1 values(50,60);
53 insert into t1 values(50,60);
54 insert into t1 values(50,60);
55 insert into t1 values(50,60);
56 insert into t1 values(50,60);