-
Notifications
You must be signed in to change notification settings - Fork 6
/
create-tables.sql
31 lines (26 loc) · 1.6 KB
/
create-tables.sql
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
create table data (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
pc VARCHAR(100),
dat DATETIME,
cpu double
);
insert into data (pc, dat, cpu) values ('pc1', '2012-01-01 23:33:30', 0.1);
insert into data (pc, dat, cpu) values ('pc1', '2012-01-01 23:34:00', 0.4);
insert into data (pc, dat, cpu) values ('pc1', '2012-01-01 23:35:00', 0.2);
insert into data (pc, dat, cpu) values ('pc1', '2012-01-01 23:36:00', 0.5);
insert into data (pc, dat, cpu) values ('pc1', '2012-01-01 23:37:00', 0.3);
insert into data (pc, dat, cpu) values ('pc1', '2012-01-01 23:38:00', 0.5);
insert into data (pc, dat, cpu) values ('pc1', '2012-01-01 23:39:00', 0.8);
insert into data (pc, dat, cpu) values ('pc1', '2012-01-01 23:40:00', 0.2);
insert into data (pc, dat, cpu) values ('pc1', '2012-01-01 23:41:00', 0.9);
insert into data (pc, dat, cpu) values ('pc1', '2012-01-01 23:42:00', 0.99);
insert into data (pc, dat, cpu) values ('pc2', '2012-01-01 23:33:30', 0.99);
insert into data (pc, dat, cpu) values ('pc2', '2012-01-01 23:34:00', 0.48);
insert into data (pc, dat, cpu) values ('pc2', '2012-01-01 23:35:00', 0.2);
insert into data (pc, dat, cpu) values ('pc2', '2012-01-01 23:36:00', 0.7);
insert into data (pc, dat, cpu) values ('pc2', '2012-01-01 23:37:00', 0.8);
insert into data (pc, dat, cpu) values ('pc2', '2012-01-01 23:38:00', 0.5);
insert into data (pc, dat, cpu) values ('pc2', '2012-01-01 23:39:00', 0.3);
insert into data (pc, dat, cpu) values ('pc2', '2012-01-01 23:40:00', 0.7);
insert into data (pc, dat, cpu) values ('pc2', '2012-01-01 23:41:00', 0.1);
insert into data (pc, dat, cpu) values ('pc2', '2012-01-01 23:42:00', 0.4);