|
1
by brian
clean slate |
1 |
DROP TABLE IF EXISTS t1;
|
2 |
select 1;
|
|
3 |
1
|
|
4 |
1
|
|
5 |
select 2;
|
|
6 |
select 3;
|
|
7 |
select 4||||
|
|
8 |
2
|
|
9 |
2
|
|
10 |
3
|
|
11 |
3
|
|
12 |
4
|
|
13 |
4
|
|
14 |
select 5;
|
|
15 |
select 6;
|
|
16 |
select 50, 'abc';'abcd'
|
|
17 |
5
|
|
18 |
5
|
|
19 |
6
|
|
20 |
6
|
|
21 |
50 abc
|
|
22 |
50 abc
|
|
23 |
select "abcd'";'abcd'
|
|
24 |
abcd'
|
|
25 |
abcd'
|
|
26 |
select "'abcd";'abcd'
|
|
27 |
'abcd
|
|
28 |
'abcd
|
|
29 |
select 5'abcd'
|
|
30 |
5
|
|
31 |
5
|
|
32 |
select 'finish';
|
|
33 |
finish
|
|
34 |
finish
|
|
35 |
flush status;
|
|
36 |
create table t1 (i int);
|
|
37 |
insert into t1 values (1);
|
|
38 |
select * from t1 where i = 1;
|
|
39 |
insert into t1 values (2),(3),(4);
|
|
40 |
select * from t1 where i = 2;
|
|
41 |
select * from t1 where i = 3||||
|
|
42 |
i
|
|
43 |
1
|
|
44 |
i
|
|
45 |
2
|
|
46 |
i
|
|
47 |
3
|
|
48 |
show status like 'Slow_queries'||||
|
|
49 |
Variable_name Value
|
|
50 |
Slow_queries 2
|
|
51 |
drop table t1||||
|