-
Notifications
You must be signed in to change notification settings - Fork 3
Expand file tree
/
Copy pathschema.sql
More file actions
28 lines (26 loc) · 1.95 KB
/
schema.sql
File metadata and controls
28 lines (26 loc) · 1.95 KB
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
-- Drop the table if it exists
DROP TABLE IF EXISTS batch_test;
-- Create sample table
CREATE TABLE batch_test (id int AUTO_INCREMENT PRIMARY key, number float default null, date datetime default null);
-- Add 100 rows
INSERT INTO batch_test (number, date)
VALUES (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null),
(RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null), (RAND(), null);