1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
DROP DATABASE IF EXISTS gt_n;
CREATE DATABASE gt_n;
USE gt_n;
CREATE TABLE t1 (
id int not null auto_increment primary key,
status varchar(32) not null,
index (status)
);
-- 12 ok, 7 bad
INSERT INTO t1 VALUES
(null, 'ok'),
(null, 'bad'),
(null, 'ok'),
(null, 'bad'),
(null, 'ok'),
(null, 'bad'),
(null, 'bad'),
(null, 'ok'),
(null, 'ok'),
(null, 'bad'),
(null, 'bad'),
(null, 'ok'),
(null, 'ok'),
(null, 'ok'),
(null, 'ok'),
(null, 'ok'),
(null, 'ok'),
(null, 'ok'),
(null, 'bad');
|
