· 7 years ago · Jan 30, 2019, 12:48 PM
1DROP TABLE IF EXISTS `table_t1`;
2CREATE TABLE IF NOT EXISTS `table_t1` (
3 `id` int(10) NOT NULL auto_increment,
4 `date` datetime,
5 `l1` integer,
6 `l2` integer,
7 `l3` integer,
8 `l4` integer,
9 `l5` integer,
10 PRIMARY KEY( `id` )
11);
12
13INSERT INTO table_t1 VALUES
14(null,'2019-01-01', 1, 2, 3, 4, 5),
15(null,'2019-01-02', 5, 7, 10, 11, 15),
16(null,'2019-01-03', 5, 8, 9, 10, 14),
17(null,'2019-01-04', 5, 8, 9, 12, 13),
18(null,'2019-01-05', 5, 8, 10, 13, 15),
19(null,'2019-01-06', 5, 8, 11, 12, 15),
20(null,'2019-01-07', 5, 9, 10, 12, 15),
21(null,'2019-01-08', 5, 9, 11, 13, 15),
22(null,'2019-01-09', 5, 10, 11, 13, 14),
23(null,'2019-01-10', 5, 12, 13, 14, 15),
24(null,'2019-01-11', 6, 7, 8, 10, 14),
25(null,'2019-01-12', 6, 7, 8, 11, 15),
26(null,'2019-01-13', 6, 7, 9, 10, 11),
27(null,'2019-01-14', 6, 7, 9, 12, 15),
28(null,'2019-01-15', 6, 7, 11, 12, 13),
29(null,'2019-01-16', 6, 8, 9, 10, 13),
30(null,'2019-01-17', 6, 8, 9, 11, 12),
31(null,'2019-01-18', 6, 8, 10, 11, 13),
32(null,'2019-01-19', 6, 8, 12, 14, 15),
33(null,'2019-01-20', 6, 9, 10, 12, 14),
34(null,'2019-01-21', 6, 10, 11, 12, 15),
35(null,'2019-01-22', 6, 11, 13, 14, 15),
36(null,'2019-01-23', 7, 8, 9, 10, 15),
37(null,'2019-01-24', 7, 8, 11, 12, 13),
38(null,'2019-01-25', 7, 8, 13, 14, 15),
39(null,'2019-01-26', 7, 9, 11, 14, 15),
40(null,'2019-01-27', 7, 9, 12, 13, 14),
41(null,'2019-01-28', 7, 10, 11, 12, 14),
42(null,'2019-01-29', 7, 10, 12, 13, 15),
43(null,'2019-01-30', 8, 9, 10, 11, 15),
44(null,'2019-01-31', 8, 9, 11, 12, 14),
45(null,'2019-02-01', 8, 9, 12, 13, 15),
46(null,'2019-02-02', 8, 10, 11, 14, 15),
47(null,'2019-02-03', 8, 10, 12, 13, 14),
48(null,'2019-02-04', 9, 10, 11, 12, 13),
49(null,'2019-02-05', 9, 10, 13, 14, 15);
50
51DROP TABLE IF EXISTS `table_t2`;
52CREATE TABLE IF NOT EXISTS `table_t2` (
53 `id` int(10) NOT NULL auto_increment,
54 `date` datetime,
55 `l1` integer,
56 `l2` integer,
57 `l3` integer,
58 `l4` integer,
59 `l5` integer,
60 PRIMARY KEY( `id` )
61);
62
63INSERT INTO `table_t2` VALUES
64(null,'2019-01-01', 1, 2, 3, 4, 5),
65(null,'2019-01-02', 5, 7, 10, 11, 15),
66(null,'2019-01-03', 5, 8, 9, 10, 14),
67(null,'2019-01-04', 5, 8, 9, 12, 13),
68(null,'2019-01-05', 5, 8, 10, 13, 15),
69(null,'2019-01-06', 5, 8, 11, 12, 15),
70(null,'2019-01-07', 5, 9, 10, 12, 15),
71(null,'2019-01-08', 5, 9, 11, 13, 15),
72(null,'2019-01-09', 5, 10, 11, 13, 14),
73(null,'2019-01-10', 5, 12, 13, 14, 15),
74(null,'2019-01-11', 6, 7, 8, 10, 14),
75(null,'2019-01-12', 6, 7, 8, 11, 15),
76(null,'2019-01-13', 6, 7, 9, 10, 11),
77(null,'2019-01-14', 6, 7, 9, 12, 15),
78(null,'2019-01-15', 6, 7, 11, 12, 13),
79(null,'2019-01-16', 6, 8, 9, 10, 13),
80(null,'2019-01-17', 6, 8, 9, 11, 12),
81(null,'2019-01-18', 6, 8, 10, 11, 13),
82(null,'2019-01-19', 6, 8, 12, 14, 15),
83(null,'2019-01-20', 6, 9, 10, 12, 14),
84(null,'2019-01-21', 6, 10, 11, 12, 15),
85(null,'2019-01-22', 6, 11, 13, 14, 15),
86(null,'2019-01-23', 7, 8, 9, 10, 15),
87(null,'2019-01-24', 7, 8, 11, 12, 13),
88(null,'2019-01-25', 7, 8, 13, 14, 15),
89(null,'2019-01-26', 7, 9, 11, 14, 15),
90(null,'2019-01-27', 7, 9, 12, 13, 14),
91(null,'2019-01-28', 7, 10, 11, 12, 14),
92(null,'2019-01-29', 7, 10, 12, 13, 15),
93(null,'2019-01-30', 8, 9, 10, 11, 15),
94(null,'2019-01-31', 8, 9, 11, 12, 14),
95(null,'2019-02-01', 8, 9, 12, 13, 15),
96(null,'2019-02-02', 8, 10, 11, 14, 15),
97(null,'2019-02-03', 8, 10, 12, 13, 14),
98(null,'2019-02-04', 9, 10, 11, 12, 13),
99(null,'2019-02-05', 9, 10, 13, 14, 15),
100(null,'2019-02-06', 19, 20, 21, 22, 33),
101(null,'2019-02-07', 19, 30, 33, 34, 35);
102
103
104DROP TABLE IF EXISTS `table_t3`;
105CREATE TABLE IF NOT EXISTS `table_t3` (
106 `id` int(10) NOT NULL auto_increment,
107 `date` datetime,
108 `l1` integer,
109 `l2` integer,
110 `l3` integer,
111 `l4` integer,
112 `l5` integer,
113 PRIMARY KEY( `id` )
114);
115
116
117INSERT INTO `table_t3` VALUES
118(null,'2019-01-01', 1, 2, 3, 4, 5),
119(null,'2019-01-02', 5, 7, 10, 11, 15),
120(null,'2019-01-03', 5, 8, 9, 10, 14),
121(null,'2019-01-04', 5, 8, 9, 12, 13),
122(null,'2019-01-05', 5, 8, 10, 13, 15),
123(null,'2019-01-06', 5, 8, 11, 12, 15),
124(null,'2019-01-07', 5, 9, 10, 12, 15),
125(null,'2019-01-08', 5, 9, 11, 13, 15),
126(null,'2019-01-09', 5, 10, 11, 13, 14),
127(null,'2019-01-10', 5, 12, 13, 14, 15),
128(null,'2019-01-11', 6, 7, 8, 10, 14),
129(null,'2019-01-12', 6, 7, 8, 11, 15),
130(null,'2019-01-13', 6, 7, 9, 10, 11),
131(null,'2019-01-14', 6, 7, 9, 12, 15),
132(null,'2019-01-15', 6, 7, 11, 12, 13),
133(null,'2019-01-16', 6, 8, 9, 10, 13),
134(null,'2019-01-17', 6, 8, 9, 11, 12),
135(null,'2019-01-18', 6, 8, 10, 11, 13),
136(null,'2019-01-19', 6, 8, 12, 14, 15),
137(null,'2019-01-20', 6, 9, 10, 12, 14),
138(null,'2019-01-21', 6, 10, 11, 12, 15),
139(null,'2019-01-22', 6, 11, 13, 14, 15),
140(null,'2019-01-23', 7, 8, 9, 10, 15),
141(null,'2019-01-24', 7, 8, 11, 12, 13),
142(null,'2019-01-25', 7, 8, 13, 14, 15),
143(null,'2019-01-26', 7, 9, 11, 14, 15),
144(null,'2019-01-27', 7, 9, 12, 13, 14),
145(null,'2019-01-28', 7, 10, 11, 12, 14),
146(null,'2019-01-29', 7, 10, 12, 13, 15),
147(null,'2019-01-30', 8, 9, 10, 11, 15),
148(null,'2019-01-31', 8, 9, 11, 12, 14),
149(null,'2019-02-01', 8, 9, 12, 13, 15),
150(null,'2019-02-02', 8, 10, 11, 14, 15),
151(null,'2019-02-03', 8, 10, 12, 13, 14),
152(null,'2019-02-04', 9, 10, 11, 12, 13),
153(null,'2019-02-05', 9, 10, 13, 14, 15),
154(null,'2019-02-06', 19, 20, 21, 22, 33),
155(null,'2019-02-07', 19, 30, 33, 34, 35),
156(null,'2019-02-08', 11, 21, 27, 32, 43),
157(null,'2019-02-09', 29, 31, 35, 37, 45);