パフォーマンステストのため２００億行のデータが必要になった。
取り合えず50万行のデータの作成とinsertをするストアドプロシージャを実行してみた。
処理時間10分。。。何日かかるんだ？
次にLOAD DATAステートメントを試してみた。
50万行のCSVファイルを挿入したら30秒ぐらいで完了した。まだまし？
ということでpythonでCSVファイルを作成してLOAD DATAステートメントで挿入する方向で考えてみることにした。
追記：２つの仮テーブルを作成し、年月データとデータをLOAD DATAステートメントで挿入し、
作成した二つの仮テーブルを直積し、対象テーブルにinsert into ... selectを実行したところ15秒で50万行のデータが挿入された。MySQLやるじゃん
はじめに
初めてのpandasでしたが便利でした。
完成プログラム
import pandas as pd
# 年月データ
date = pd.read_csv('./date.csv')
# データ
list = pd.read_csv('./list.csv')
# 直積はデータが膨大になる可能性があるのでファイルを分割して出力
for i in range(0,100,10):
get_rows = list[i:i+10]
# 直積
d = date.join(get_rows, how='cross')
# CSV出力
d.to_csv('./aa' + str(i+10) + '.csv')
print("end")
年月データの一部
date
2023/12/1 0:00
2023/12/1 0:30
2023/12/1 1:00
2023/12/1 1:30
2023/12/1 2:00
2023/12/1 2:30
2023/12/1 3:00
2023/12/1 3:30
2023/12/1 4:00
2023/12/1 4:30
2023/12/1 5:00
2023/12/1 5:30
2023/12/1 6:00
2023/12/1 6:30
2023/12/1 7:00
2023/12/1 7:30
2023/12/1 8:00
2023/12/1 8:30
2023/12/1 9:00
2023/12/1 9:30
2023/12/1 10:00
2023/12/1 10:30
2023/12/1 11:00
2023/12/1 11:30
2023/12/1 12:00
2023/12/1 12:30
2023/12/1 13:00
2023/12/1 13:30
2023/12/1 14:00
2023/12/1 14:30
2023/12/1 15:00
2023/12/1 15:30
2023/12/1 16:00
2023/12/1 16:30
2023/12/1 17:00
2023/12/1 17:30
2023/12/1 18:00
2023/12/1 18:30
2023/12/1 19:00
2023/12/1 19:30
2023/12/1 20:00
2023/12/1 20:30
2023/12/1 21:00
2023/12/1 21:30
2023/12/1 22:00
2023/12/1 22:30
2023/12/1 23:00
2023/12/1 23:30
データの一部
id,order,code,name
a00,1,a00:xxx,xxx
a01,1,a01:xxx,xxx
a02,1,a02:xxx,xxx
a03,1,a03:xxx,xxx
a04,1,a04:xxx,xxx
a05,1,a05:xxx,xxx
a06,1,a06:xxx,xxx
a07,1,a07:xxx,xxx
a08,1,a08:xxx,xxx
a09,1,a09:xxx,xxx
a10,1,a10:xxx,xxx
a11,1,a11:xxx,xxx
a12,1,a12:xxx,xxx
a13,1,a13:xxx,xxx
a14,1,a14:xxx,xxx
a15,1,a15:xxx,xxx
a16,1,a16:xxx,xxx
a17,1,a17:xxx,xxx
a18,1,a18:xxx,xxx
a19,1,a19:xxx,xxx
a20,1,a20:xxx,xxx
a21,1,a21:xxx,xxx
a22,1,a22:xxx,xxx
a23,1,a23:xxx,xxx
a24,1,a24:xxx,xxx
a25,1,a25:xxx,xxx
a26,1,a26:xxx,xxx
a27,1,a27:xxx,xxx
a28,1,a28:xxx,xxx
a29,1,a29:xxx,xxx
a30,1,a30:xxx,xxx
a31,1,a31:xxx,xxx
a32,1,a32:xxx,xxx
a33,1,a33:xxx,xxx
a34,1,a34:xxx,xxx
a35,1,a35:xxx,xxx
a36,1,a36:xxx,xxx
a37,1,a37:xxx,xxx
a38,1,a38:xxx,xxx
a39,1,a39:xxx,xxx
a40,1,a40:xxx,xxx
a41,1,a41:xxx,xxx
a42,1,a42:xxx,xxx
a43,1,a43:xxx,xxx
a44,1,a44:xxx,xxx
a45,1,a45:xxx,xxx
a46,1,a46:xxx,xxx
a47,1,a47:xxx,xxx
a48,1,a48:xxx,xxx
a49,1,a49:xxx,xxx
a50,1,a50:xxx,xxx
a51,1,a51:xxx,xxx
a52,1,a52:xxx,xxx
a53,1,a53:xxx,xxx
a54,1,a54:xxx,xxx
a55,1,a55:xxx,xxx
a56,1,a56:xxx,xxx
a57,1,a57:xxx,xxx
a58,1,a58:xxx,xxx
a59,1,a59:xxx,xxx
a60,1,a60:xxx,xxx
a61,1,a61:xxx,xxx
a62,1,a62:xxx,xxx
a63,1,a63:xxx,xxx
a64,1,a64:xxx,xxx
a65,1,a65:xxx,xxx
a66,1,a66:xxx,xxx
a67,1,a67:xxx,xxx
a68,1,a68:xxx,xxx
a69,1,a69:xxx,xxx
a70,1,a70:xxx,xxx
a71,1,a71:xxx,xxx
a72,1,a72:xxx,xxx
a73,1,a73:xxx,xxx
a74,1,a74:xxx,xxx
a75,1,a75:xxx,xxx
a76,1,a76:xxx,xxx
a77,1,a77:xxx,xxx
a78,1,a78:xxx,xxx
a79,1,a79:xxx,xxx
a80,1,a80:xxx,xxx
a81,1,a81:xxx,xxx
a82,1,a82:xxx,xxx
a83,1,a83:xxx,xxx
a84,1,a84:xxx,xxx
a85,1,a85:xxx,xxx
a86,1,a86:xxx,xxx
a87,1,a87:xxx,xxx
a88,1,a88:xxx,xxx
a89,1,a89:xxx,xxx
a90,1,a90:xxx,xxx
a91,1,a91:xxx,xxx
a92,1,a92:xxx,xxx
a93,1,a93:xxx,xxx
a94,1,a94:xxx,xxx
a95,1,a95:xxx,xxx
a96,1,a96:xxx,xxx
a97,1,a97:xxx,xxx
a98,1,a98:xxx,xxx
a99,1,a99:xxx,xxx
出力結果(データの10行分)
,date,id,order,code,name
0,2023/12/1 0:00,a00,1,a00:xxx,xxx
10,2023/12/1 0:30,a00,1,a00:xxx,xxx
20,2023/12/1 1:00,a00,1,a00:xxx,xxx
30,2023/12/1 1:30,a00,1,a00:xxx,xxx
40,2023/12/1 2:00,a00,1,a00:xxx,xxx
50,2023/12/1 2:30,a00,1,a00:xxx,xxx
60,2023/12/1 3:00,a00,1,a00:xxx,xxx
70,2023/12/1 3:30,a00,1,a00:xxx,xxx
80,2023/12/1 4:00,a00,1,a00:xxx,xxx
90,2023/12/1 4:30,a00,1,a00:xxx,xxx
100,2023/12/1 5:00,a00,1,a00:xxx,xxx
110,2023/12/1 5:30,a00,1,a00:xxx,xxx
120,2023/12/1 6:00,a00,1,a00:xxx,xxx
130,2023/12/1 6:30,a00,1,a00:xxx,xxx
140,2023/12/1 7:00,a00,1,a00:xxx,xxx
150,2023/12/1 7:30,a00,1,a00:xxx,xxx
160,2023/12/1 8:00,a00,1,a00:xxx,xxx
170,2023/12/1 8:30,a00,1,a00:xxx,xxx
180,2023/12/1 9:00,a00,1,a00:xxx,xxx
190,2023/12/1 9:30,a00,1,a00:xxx,xxx
200,2023/12/1 10:00,a00,1,a00:xxx,xxx
210,2023/12/1 10:30,a00,1,a00:xxx,xxx
220,2023/12/1 11:00,a00,1,a00:xxx,xxx
230,2023/12/1 11:30,a00,1,a00:xxx,xxx
240,2023/12/1 12:00,a00,1,a00:xxx,xxx
250,2023/12/1 12:30,a00,1,a00:xxx,xxx
260,2023/12/1 13:00,a00,1,a00:xxx,xxx
270,2023/12/1 13:30,a00,1,a00:xxx,xxx
280,2023/12/1 14:00,a00,1,a00:xxx,xxx
290,2023/12/1 14:30,a00,1,a00:xxx,xxx
300,2023/12/1 15:00,a00,1,a00:xxx,xxx
310,2023/12/1 15:30,a00,1,a00:xxx,xxx
320,2023/12/1 16:00,a00,1,a00:xxx,xxx
330,2023/12/1 16:30,a00,1,a00:xxx,xxx
340,2023/12/1 17:00,a00,1,a00:xxx,xxx
350,2023/12/1 17:30,a00,1,a00:xxx,xxx
360,2023/12/1 18:00,a00,1,a00:xxx,xxx
370,2023/12/1 18:30,a00,1,a00:xxx,xxx
380,2023/12/1 19:00,a00,1,a00:xxx,xxx
390,2023/12/1 19:30,a00,1,a00:xxx,xxx
400,2023/12/1 20:00,a00,1,a00:xxx,xxx
410,2023/12/1 20:30,a00,1,a00:xxx,xxx
420,2023/12/1 21:00,a00,1,a00:xxx,xxx
430,2023/12/1 21:30,a00,1,a00:xxx,xxx
440,2023/12/1 22:00,a00,1,a00:xxx,xxx
450,2023/12/1 22:30,a00,1,a00:xxx,xxx
460,2023/12/1 23:00,a00,1,a00:xxx,xxx
470,2023/12/1 23:30,a00,1,a00:xxx,xxx
1,2023/12/1 0:00,a01,1,a01:xxx,xxx
11,2023/12/1 0:30,a01,1,a01:xxx,xxx
21,2023/12/1 1:00,a01,1,a01:xxx,xxx
31,2023/12/1 1:30,a01,1,a01:xxx,xxx
41,2023/12/1 2:00,a01,1,a01:xxx,xxx
51,2023/12/1 2:30,a01,1,a01:xxx,xxx
61,2023/12/1 3:00,a01,1,a01:xxx,xxx
71,2023/12/1 3:30,a01,1,a01:xxx,xxx
81,2023/12/1 4:00,a01,1,a01:xxx,xxx
91,2023/12/1 4:30,a01,1,a01:xxx,xxx
101,2023/12/1 5:00,a01,1,a01:xxx,xxx
111,2023/12/1 5:30,a01,1,a01:xxx,xxx
121,2023/12/1 6:00,a01,1,a01:xxx,xxx
131,2023/12/1 6:30,a01,1,a01:xxx,xxx
141,2023/12/1 7:00,a01,1,a01:xxx,xxx
151,2023/12/1 7:30,a01,1,a01:xxx,xxx
161,2023/12/1 8:00,a01,1,a01:xxx,xxx
171,2023/12/1 8:30,a01,1,a01:xxx,xxx
181,2023/12/1 9:00,a01,1,a01:xxx,xxx
191,2023/12/1 9:30,a01,1,a01:xxx,xxx
201,2023/12/1 10:00,a01,1,a01:xxx,xxx
211,2023/12/1 10:30,a01,1,a01:xxx,xxx
221,2023/12/1 11:00,a01,1,a01:xxx,xxx
231,2023/12/1 11:30,a01,1,a01:xxx,xxx
241,2023/12/1 12:00,a01,1,a01:xxx,xxx
251,2023/12/1 12:30,a01,1,a01:xxx,xxx
261,2023/12/1 13:00,a01,1,a01:xxx,xxx
271,2023/12/1 13:30,a01,1,a01:xxx,xxx
281,2023/12/1 14:00,a01,1,a01:xxx,xxx
291,2023/12/1 14:30,a01,1,a01:xxx,xxx
301,2023/12/1 15:00,a01,1,a01:xxx,xxx
311,2023/12/1 15:30,a01,1,a01:xxx,xxx
321,2023/12/1 16:00,a01,1,a01:xxx,xxx
331,2023/12/1 16:30,a01,1,a01:xxx,xxx
341,2023/12/1 17:00,a01,1,a01:xxx,xxx
351,2023/12/1 17:30,a01,1,a01:xxx,xxx
361,2023/12/1 18:00,a01,1,a01:xxx,xxx
371,2023/12/1 18:30,a01,1,a01:xxx,xxx
381,2023/12/1 19:00,a01,1,a01:xxx,xxx
391,2023/12/1 19:30,a01,1,a01:xxx,xxx
401,2023/12/1 20:00,a01,1,a01:xxx,xxx
411,2023/12/1 20:30,a01,1,a01:xxx,xxx
421,2023/12/1 21:00,a01,1,a01:xxx,xxx
431,2023/12/1 21:30,a01,1,a01:xxx,xxx
441,2023/12/1 22:00,a01,1,a01:xxx,xxx
451,2023/12/1 22:30,a01,1,a01:xxx,xxx
461,2023/12/1 23:00,a01,1,a01:xxx,xxx
471,2023/12/1 23:30,a01,1,a01:xxx,xxx
2,2023/12/1 0:00,a02,1,a02:xxx,xxx
12,2023/12/1 0:30,a02,1,a02:xxx,xxx
22,2023/12/1 1:00,a02,1,a02:xxx,xxx
32,2023/12/1 1:30,a02,1,a02:xxx,xxx
42,2023/12/1 2:00,a02,1,a02:xxx,xxx
52,2023/12/1 2:30,a02,1,a02:xxx,xxx
62,2023/12/1 3:00,a02,1,a02:xxx,xxx
72,2023/12/1 3:30,a02,1,a02:xxx,xxx
82,2023/12/1 4:00,a02,1,a02:xxx,xxx
92,2023/12/1 4:30,a02,1,a02:xxx,xxx
102,2023/12/1 5:00,a02,1,a02:xxx,xxx
112,2023/12/1 5:30,a02,1,a02:xxx,xxx
122,2023/12/1 6:00,a02,1,a02:xxx,xxx
132,2023/12/1 6:30,a02,1,a02:xxx,xxx
142,2023/12/1 7:00,a02,1,a02:xxx,xxx
152,2023/12/1 7:30,a02,1,a02:xxx,xxx
162,2023/12/1 8:00,a02,1,a02:xxx,xxx
172,2023/12/1 8:30,a02,1,a02:xxx,xxx
182,2023/12/1 9:00,a02,1,a02:xxx,xxx
192,2023/12/1 9:30,a02,1,a02:xxx,xxx
202,2023/12/1 10:00,a02,1,a02:xxx,xxx
212,2023/12/1 10:30,a02,1,a02:xxx,xxx
222,2023/12/1 11:00,a02,1,a02:xxx,xxx
232,2023/12/1 11:30,a02,1,a02:xxx,xxx
242,2023/12/1 12:00,a02,1,a02:xxx,xxx
252,2023/12/1 12:30,a02,1,a02:xxx,xxx
262,2023/12/1 13:00,a02,1,a02:xxx,xxx
272,2023/12/1 13:30,a02,1,a02:xxx,xxx
282,2023/12/1 14:00,a02,1,a02:xxx,xxx
292,2023/12/1 14:30,a02,1,a02:xxx,xxx
302,2023/12/1 15:00,a02,1,a02:xxx,xxx
312,2023/12/1 15:30,a02,1,a02:xxx,xxx
322,2023/12/1 16:00,a02,1,a02:xxx,xxx
332,2023/12/1 16:30,a02,1,a02:xxx,xxx
342,2023/12/1 17:00,a02,1,a02:xxx,xxx
352,2023/12/1 17:30,a02,1,a02:xxx,xxx
362,2023/12/1 18:00,a02,1,a02:xxx,xxx
372,2023/12/1 18:30,a02,1,a02:xxx,xxx
382,2023/12/1 19:00,a02,1,a02:xxx,xxx
392,2023/12/1 19:30,a02,1,a02:xxx,xxx
402,2023/12/1 20:00,a02,1,a02:xxx,xxx
412,2023/12/1 20:30,a02,1,a02:xxx,xxx
422,2023/12/1 21:00,a02,1,a02:xxx,xxx
432,2023/12/1 21:30,a02,1,a02:xxx,xxx
442,2023/12/1 22:00,a02,1,a02:xxx,xxx
452,2023/12/1 22:30,a02,1,a02:xxx,xxx
462,2023/12/1 23:00,a02,1,a02:xxx,xxx
472,2023/12/1 23:30,a02,1,a02:xxx,xxx
3,2023/12/1 0:00,a03,1,a03:xxx,xxx
13,2023/12/1 0:30,a03,1,a03:xxx,xxx
23,2023/12/1 1:00,a03,1,a03:xxx,xxx
33,2023/12/1 1:30,a03,1,a03:xxx,xxx
43,2023/12/1 2:00,a03,1,a03:xxx,xxx
53,2023/12/1 2:30,a03,1,a03:xxx,xxx
63,2023/12/1 3:00,a03,1,a03:xxx,xxx
73,2023/12/1 3:30,a03,1,a03:xxx,xxx
83,2023/12/1 4:00,a03,1,a03:xxx,xxx
93,2023/12/1 4:30,a03,1,a03:xxx,xxx
103,2023/12/1 5:00,a03,1,a03:xxx,xxx
113,2023/12/1 5:30,a03,1,a03:xxx,xxx
123,2023/12/1 6:00,a03,1,a03:xxx,xxx
133,2023/12/1 6:30,a03,1,a03:xxx,xxx
143,2023/12/1 7:00,a03,1,a03:xxx,xxx
153,2023/12/1 7:30,a03,1,a03:xxx,xxx
163,2023/12/1 8:00,a03,1,a03:xxx,xxx
173,2023/12/1 8:30,a03,1,a03:xxx,xxx
183,2023/12/1 9:00,a03,1,a03:xxx,xxx
193,2023/12/1 9:30,a03,1,a03:xxx,xxx
203,2023/12/1 10:00,a03,1,a03:xxx,xxx
213,2023/12/1 10:30,a03,1,a03:xxx,xxx
223,2023/12/1 11:00,a03,1,a03:xxx,xxx
233,2023/12/1 11:30,a03,1,a03:xxx,xxx
243,2023/12/1 12:00,a03,1,a03:xxx,xxx
253,2023/12/1 12:30,a03,1,a03:xxx,xxx
263,2023/12/1 13:00,a03,1,a03:xxx,xxx
273,2023/12/1 13:30,a03,1,a03:xxx,xxx
283,2023/12/1 14:00,a03,1,a03:xxx,xxx
293,2023/12/1 14:30,a03,1,a03:xxx,xxx
303,2023/12/1 15:00,a03,1,a03:xxx,xxx
313,2023/12/1 15:30,a03,1,a03:xxx,xxx
323,2023/12/1 16:00,a03,1,a03:xxx,xxx
333,2023/12/1 16:30,a03,1,a03:xxx,xxx
343,2023/12/1 17:00,a03,1,a03:xxx,xxx
353,2023/12/1 17:30,a03,1,a03:xxx,xxx
363,2023/12/1 18:00,a03,1,a03:xxx,xxx
373,2023/12/1 18:30,a03,1,a03:xxx,xxx
383,2023/12/1 19:00,a03,1,a03:xxx,xxx
393,2023/12/1 19:30,a03,1,a03:xxx,xxx
403,2023/12/1 20:00,a03,1,a03:xxx,xxx
413,2023/12/1 20:30,a03,1,a03:xxx,xxx
423,2023/12/1 21:00,a03,1,a03:xxx,xxx
433,2023/12/1 21:30,a03,1,a03:xxx,xxx
443,2023/12/1 22:00,a03,1,a03:xxx,xxx
453,2023/12/1 22:30,a03,1,a03:xxx,xxx
463,2023/12/1 23:00,a03,1,a03:xxx,xxx
473,2023/12/1 23:30,a03,1,a03:xxx,xxx
4,2023/12/1 0:00,a04,1,a04:xxx,xxx
14,2023/12/1 0:30,a04,1,a04:xxx,xxx
24,2023/12/1 1:00,a04,1,a04:xxx,xxx
34,2023/12/1 1:30,a04,1,a04:xxx,xxx
44,2023/12/1 2:00,a04,1,a04:xxx,xxx
54,2023/12/1 2:30,a04,1,a04:xxx,xxx
64,2023/12/1 3:00,a04,1,a04:xxx,xxx
74,2023/12/1 3:30,a04,1,a04:xxx,xxx
84,2023/12/1 4:00,a04,1,a04:xxx,xxx
94,2023/12/1 4:30,a04,1,a04:xxx,xxx
104,2023/12/1 5:00,a04,1,a04:xxx,xxx
114,2023/12/1 5:30,a04,1,a04:xxx,xxx
124,2023/12/1 6:00,a04,1,a04:xxx,xxx
134,2023/12/1 6:30,a04,1,a04:xxx,xxx
144,2023/12/1 7:00,a04,1,a04:xxx,xxx
154,2023/12/1 7:30,a04,1,a04:xxx,xxx
164,2023/12/1 8:00,a04,1,a04:xxx,xxx
174,2023/12/1 8:30,a04,1,a04:xxx,xxx
184,2023/12/1 9:00,a04,1,a04:xxx,xxx
194,2023/12/1 9:30,a04,1,a04:xxx,xxx
204,2023/12/1 10:00,a04,1,a04:xxx,xxx
214,2023/12/1 10:30,a04,1,a04:xxx,xxx
224,2023/12/1 11:00,a04,1,a04:xxx,xxx
234,2023/12/1 11:30,a04,1,a04:xxx,xxx
244,2023/12/1 12:00,a04,1,a04:xxx,xxx
254,2023/12/1 12:30,a04,1,a04:xxx,xxx
264,2023/12/1 13:00,a04,1,a04:xxx,xxx
274,2023/12/1 13:30,a04,1,a04:xxx,xxx
284,2023/12/1 14:00,a04,1,a04:xxx,xxx
294,2023/12/1 14:30,a04,1,a04:xxx,xxx
304,2023/12/1 15:00,a04,1,a04:xxx,xxx
314,2023/12/1 15:30,a04,1,a04:xxx,xxx
324,2023/12/1 16:00,a04,1,a04:xxx,xxx
334,2023/12/1 16:30,a04,1,a04:xxx,xxx
344,2023/12/1 17:00,a04,1,a04:xxx,xxx
354,2023/12/1 17:30,a04,1,a04:xxx,xxx
364,2023/12/1 18:00,a04,1,a04:xxx,xxx
374,2023/12/1 18:30,a04,1,a04:xxx,xxx
384,2023/12/1 19:00,a04,1,a04:xxx,xxx
394,2023/12/1 19:30,a04,1,a04:xxx,xxx
404,2023/12/1 20:00,a04,1,a04:xxx,xxx
414,2023/12/1 20:30,a04,1,a04:xxx,xxx
424,2023/12/1 21:00,a04,1,a04:xxx,xxx
434,2023/12/1 21:30,a04,1,a04:xxx,xxx
444,2023/12/1 22:00,a04,1,a04:xxx,xxx
454,2023/12/1 22:30,a04,1,a04:xxx,xxx
464,2023/12/1 23:00,a04,1,a04:xxx,xxx
474,2023/12/1 23:30,a04,1,a04:xxx,xxx
5,2023/12/1 0:00,a05,1,a05:xxx,xxx
15,2023/12/1 0:30,a05,1,a05:xxx,xxx
25,2023/12/1 1:00,a05,1,a05:xxx,xxx
35,2023/12/1 1:30,a05,1,a05:xxx,xxx
45,2023/12/1 2:00,a05,1,a05:xxx,xxx
55,2023/12/1 2:30,a05,1,a05:xxx,xxx
65,2023/12/1 3:00,a05,1,a05:xxx,xxx
75,2023/12/1 3:30,a05,1,a05:xxx,xxx
85,2023/12/1 4:00,a05,1,a05:xxx,xxx
95,2023/12/1 4:30,a05,1,a05:xxx,xxx
105,2023/12/1 5:00,a05,1,a05:xxx,xxx
115,2023/12/1 5:30,a05,1,a05:xxx,xxx
125,2023/12/1 6:00,a05,1,a05:xxx,xxx
135,2023/12/1 6:30,a05,1,a05:xxx,xxx
145,2023/12/1 7:00,a05,1,a05:xxx,xxx
155,2023/12/1 7:30,a05,1,a05:xxx,xxx
165,2023/12/1 8:00,a05,1,a05:xxx,xxx
175,2023/12/1 8:30,a05,1,a05:xxx,xxx
185,2023/12/1 9:00,a05,1,a05:xxx,xxx
195,2023/12/1 9:30,a05,1,a05:xxx,xxx
205,2023/12/1 10:00,a05,1,a05:xxx,xxx
215,2023/12/1 10:30,a05,1,a05:xxx,xxx
225,2023/12/1 11:00,a05,1,a05:xxx,xxx
235,2023/12/1 11:30,a05,1,a05:xxx,xxx
245,2023/12/1 12:00,a05,1,a05:xxx,xxx
255,2023/12/1 12:30,a05,1,a05:xxx,xxx
265,2023/12/1 13:00,a05,1,a05:xxx,xxx
275,2023/12/1 13:30,a05,1,a05:xxx,xxx
285,2023/12/1 14:00,a05,1,a05:xxx,xxx
295,2023/12/1 14:30,a05,1,a05:xxx,xxx
305,2023/12/1 15:00,a05,1,a05:xxx,xxx
315,2023/12/1 15:30,a05,1,a05:xxx,xxx
325,2023/12/1 16:00,a05,1,a05:xxx,xxx
335,2023/12/1 16:30,a05,1,a05:xxx,xxx
345,2023/12/1 17:00,a05,1,a05:xxx,xxx
355,2023/12/1 17:30,a05,1,a05:xxx,xxx
365,2023/12/1 18:00,a05,1,a05:xxx,xxx
375,2023/12/1 18:30,a05,1,a05:xxx,xxx
385,2023/12/1 19:00,a05,1,a05:xxx,xxx
395,2023/12/1 19:30,a05,1,a05:xxx,xxx
405,2023/12/1 20:00,a05,1,a05:xxx,xxx
415,2023/12/1 20:30,a05,1,a05:xxx,xxx
425,2023/12/1 21:00,a05,1,a05:xxx,xxx
435,2023/12/1 21:30,a05,1,a05:xxx,xxx
445,2023/12/1 22:00,a05,1,a05:xxx,xxx
455,2023/12/1 22:30,a05,1,a05:xxx,xxx
465,2023/12/1 23:00,a05,1,a05:xxx,xxx
475,2023/12/1 23:30,a05,1,a05:xxx,xxx
6,2023/12/1 0:00,a06,1,a06:xxx,xxx
16,2023/12/1 0:30,a06,1,a06:xxx,xxx
26,2023/12/1 1:00,a06,1,a06:xxx,xxx
36,2023/12/1 1:30,a06,1,a06:xxx,xxx
46,2023/12/1 2:00,a06,1,a06:xxx,xxx
56,2023/12/1 2:30,a06,1,a06:xxx,xxx
66,2023/12/1 3:00,a06,1,a06:xxx,xxx
76,2023/12/1 3:30,a06,1,a06:xxx,xxx
86,2023/12/1 4:00,a06,1,a06:xxx,xxx
96,2023/12/1 4:30,a06,1,a06:xxx,xxx
106,2023/12/1 5:00,a06,1,a06:xxx,xxx
116,2023/12/1 5:30,a06,1,a06:xxx,xxx
126,2023/12/1 6:00,a06,1,a06:xxx,xxx
136,2023/12/1 6:30,a06,1,a06:xxx,xxx
146,2023/12/1 7:00,a06,1,a06:xxx,xxx
156,2023/12/1 7:30,a06,1,a06:xxx,xxx
166,2023/12/1 8:00,a06,1,a06:xxx,xxx
176,2023/12/1 8:30,a06,1,a06:xxx,xxx
186,2023/12/1 9:00,a06,1,a06:xxx,xxx
196,2023/12/1 9:30,a06,1,a06:xxx,xxx
206,2023/12/1 10:00,a06,1,a06:xxx,xxx
216,2023/12/1 10:30,a06,1,a06:xxx,xxx
226,2023/12/1 11:00,a06,1,a06:xxx,xxx
236,2023/12/1 11:30,a06,1,a06:xxx,xxx
246,2023/12/1 12:00,a06,1,a06:xxx,xxx
256,2023/12/1 12:30,a06,1,a06:xxx,xxx
266,2023/12/1 13:00,a06,1,a06:xxx,xxx
276,2023/12/1 13:30,a06,1,a06:xxx,xxx
286,2023/12/1 14:00,a06,1,a06:xxx,xxx
296,2023/12/1 14:30,a06,1,a06:xxx,xxx
306,2023/12/1 15:00,a06,1,a06:xxx,xxx
316,2023/12/1 15:30,a06,1,a06:xxx,xxx
326,2023/12/1 16:00,a06,1,a06:xxx,xxx
336,2023/12/1 16:30,a06,1,a06:xxx,xxx
346,2023/12/1 17:00,a06,1,a06:xxx,xxx
356,2023/12/1 17:30,a06,1,a06:xxx,xxx
366,2023/12/1 18:00,a06,1,a06:xxx,xxx
376,2023/12/1 18:30,a06,1,a06:xxx,xxx
386,2023/12/1 19:00,a06,1,a06:xxx,xxx
396,2023/12/1 19:30,a06,1,a06:xxx,xxx
406,2023/12/1 20:00,a06,1,a06:xxx,xxx
416,2023/12/1 20:30,a06,1,a06:xxx,xxx
426,2023/12/1 21:00,a06,1,a06:xxx,xxx
436,2023/12/1 21:30,a06,1,a06:xxx,xxx
446,2023/12/1 22:00,a06,1,a06:xxx,xxx
456,2023/12/1 22:30,a06,1,a06:xxx,xxx
466,2023/12/1 23:00,a06,1,a06:xxx,xxx
476,2023/12/1 23:30,a06,1,a06:xxx,xxx
7,2023/12/1 0:00,a07,1,a07:xxx,xxx
17,2023/12/1 0:30,a07,1,a07:xxx,xxx
27,2023/12/1 1:00,a07,1,a07:xxx,xxx
37,2023/12/1 1:30,a07,1,a07:xxx,xxx
47,2023/12/1 2:00,a07,1,a07:xxx,xxx
57,2023/12/1 2:30,a07,1,a07:xxx,xxx
67,2023/12/1 3:00,a07,1,a07:xxx,xxx
77,2023/12/1 3:30,a07,1,a07:xxx,xxx
87,2023/12/1 4:00,a07,1,a07:xxx,xxx
97,2023/12/1 4:30,a07,1,a07:xxx,xxx
107,2023/12/1 5:00,a07,1,a07:xxx,xxx
117,2023/12/1 5:30,a07,1,a07:xxx,xxx
127,2023/12/1 6:00,a07,1,a07:xxx,xxx
137,2023/12/1 6:30,a07,1,a07:xxx,xxx
147,2023/12/1 7:00,a07,1,a07:xxx,xxx
157,2023/12/1 7:30,a07,1,a07:xxx,xxx
167,2023/12/1 8:00,a07,1,a07:xxx,xxx
177,2023/12/1 8:30,a07,1,a07:xxx,xxx
187,2023/12/1 9:00,a07,1,a07:xxx,xxx
197,2023/12/1 9:30,a07,1,a07:xxx,xxx
207,2023/12/1 10:00,a07,1,a07:xxx,xxx
217,2023/12/1 10:30,a07,1,a07:xxx,xxx
227,2023/12/1 11:00,a07,1,a07:xxx,xxx
237,2023/12/1 11:30,a07,1,a07:xxx,xxx
247,2023/12/1 12:00,a07,1,a07:xxx,xxx
257,2023/12/1 12:30,a07,1,a07:xxx,xxx
267,2023/12/1 13:00,a07,1,a07:xxx,xxx
277,2023/12/1 13:30,a07,1,a07:xxx,xxx
287,2023/12/1 14:00,a07,1,a07:xxx,xxx
297,2023/12/1 14:30,a07,1,a07:xxx,xxx
307,2023/12/1 15:00,a07,1,a07:xxx,xxx
317,2023/12/1 15:30,a07,1,a07:xxx,xxx
327,2023/12/1 16:00,a07,1,a07:xxx,xxx
337,2023/12/1 16:30,a07,1,a07:xxx,xxx
347,2023/12/1 17:00,a07,1,a07:xxx,xxx
357,2023/12/1 17:30,a07,1,a07:xxx,xxx
367,2023/12/1 18:00,a07,1,a07:xxx,xxx
377,2023/12/1 18:30,a07,1,a07:xxx,xxx
387,2023/12/1 19:00,a07,1,a07:xxx,xxx
397,2023/12/1 19:30,a07,1,a07:xxx,xxx
407,2023/12/1 20:00,a07,1,a07:xxx,xxx
417,2023/12/1 20:30,a07,1,a07:xxx,xxx
427,2023/12/1 21:00,a07,1,a07:xxx,xxx
437,2023/12/1 21:30,a07,1,a07:xxx,xxx
447,2023/12/1 22:00,a07,1,a07:xxx,xxx
457,2023/12/1 22:30,a07,1,a07:xxx,xxx
467,2023/12/1 23:00,a07,1,a07:xxx,xxx
477,2023/12/1 23:30,a07,1,a07:xxx,xxx
8,2023/12/1 0:00,a08,1,a08:xxx,xxx
18,2023/12/1 0:30,a08,1,a08:xxx,xxx
28,2023/12/1 1:00,a08,1,a08:xxx,xxx
38,2023/12/1 1:30,a08,1,a08:xxx,xxx
48,2023/12/1 2:00,a08,1,a08:xxx,xxx
58,2023/12/1 2:30,a08,1,a08:xxx,xxx
68,2023/12/1 3:00,a08,1,a08:xxx,xxx
78,2023/12/1 3:30,a08,1,a08:xxx,xxx
88,2023/12/1 4:00,a08,1,a08:xxx,xxx
98,2023/12/1 4:30,a08,1,a08:xxx,xxx
108,2023/12/1 5:00,a08,1,a08:xxx,xxx
118,2023/12/1 5:30,a08,1,a08:xxx,xxx
128,2023/12/1 6:00,a08,1,a08:xxx,xxx
138,2023/12/1 6:30,a08,1,a08:xxx,xxx
148,2023/12/1 7:00,a08,1,a08:xxx,xxx
158,2023/12/1 7:30,a08,1,a08:xxx,xxx
168,2023/12/1 8:00,a08,1,a08:xxx,xxx
178,2023/12/1 8:30,a08,1,a08:xxx,xxx
188,2023/12/1 9:00,a08,1,a08:xxx,xxx
198,2023/12/1 9:30,a08,1,a08:xxx,xxx
208,2023/12/1 10:00,a08,1,a08:xxx,xxx
218,2023/12/1 10:30,a08,1,a08:xxx,xxx
228,2023/12/1 11:00,a08,1,a08:xxx,xxx
238,2023/12/1 11:30,a08,1,a08:xxx,xxx
248,2023/12/1 12:00,a08,1,a08:xxx,xxx
258,2023/12/1 12:30,a08,1,a08:xxx,xxx
268,2023/12/1 13:00,a08,1,a08:xxx,xxx
278,2023/12/1 13:30,a08,1,a08:xxx,xxx
288,2023/12/1 14:00,a08,1,a08:xxx,xxx
298,2023/12/1 14:30,a08,1,a08:xxx,xxx
308,2023/12/1 15:00,a08,1,a08:xxx,xxx
318,2023/12/1 15:30,a08,1,a08:xxx,xxx
328,2023/12/1 16:00,a08,1,a08:xxx,xxx
338,2023/12/1 16:30,a08,1,a08:xxx,xxx
348,2023/12/1 17:00,a08,1,a08:xxx,xxx
358,2023/12/1 17:30,a08,1,a08:xxx,xxx
368,2023/12/1 18:00,a08,1,a08:xxx,xxx
378,2023/12/1 18:30,a08,1,a08:xxx,xxx
388,2023/12/1 19:00,a08,1,a08:xxx,xxx
398,2023/12/1 19:30,a08,1,a08:xxx,xxx
408,2023/12/1 20:00,a08,1,a08:xxx,xxx
418,2023/12/1 20:30,a08,1,a08:xxx,xxx
428,2023/12/1 21:00,a08,1,a08:xxx,xxx
438,2023/12/1 21:30,a08,1,a08:xxx,xxx
448,2023/12/1 22:00,a08,1,a08:xxx,xxx
458,2023/12/1 22:30,a08,1,a08:xxx,xxx
468,2023/12/1 23:00,a08,1,a08:xxx,xxx
478,2023/12/1 23:30,a08,1,a08:xxx,xxx
9,2023/12/1 0:00,a09,1,a09:xxx,xxx
19,2023/12/1 0:30,a09,1,a09:xxx,xxx
29,2023/12/1 1:00,a09,1,a09:xxx,xxx
39,2023/12/1 1:30,a09,1,a09:xxx,xxx
49,2023/12/1 2:00,a09,1,a09:xxx,xxx
59,2023/12/1 2:30,a09,1,a09:xxx,xxx
69,2023/12/1 3:00,a09,1,a09:xxx,xxx
79,2023/12/1 3:30,a09,1,a09:xxx,xxx
89,2023/12/1 4:00,a09,1,a09:xxx,xxx
99,2023/12/1 4:30,a09,1,a09:xxx,xxx
109,2023/12/1 5:00,a09,1,a09:xxx,xxx
119,2023/12/1 5:30,a09,1,a09:xxx,xxx
129,2023/12/1 6:00,a09,1,a09:xxx,xxx
139,2023/12/1 6:30,a09,1,a09:xxx,xxx
149,2023/12/1 7:00,a09,1,a09:xxx,xxx
159,2023/12/1 7:30,a09,1,a09:xxx,xxx
169,2023/12/1 8:00,a09,1,a09:xxx,xxx
179,2023/12/1 8:30,a09,1,a09:xxx,xxx
189,2023/12/1 9:00,a09,1,a09:xxx,xxx
199,2023/12/1 9:30,a09,1,a09:xxx,xxx
209,2023/12/1 10:00,a09,1,a09:xxx,xxx
219,2023/12/1 10:30,a09,1,a09:xxx,xxx
229,2023/12/1 11:00,a09,1,a09:xxx,xxx
239,2023/12/1 11:30,a09,1,a09:xxx,xxx
249,2023/12/1 12:00,a09,1,a09:xxx,xxx
259,2023/12/1 12:30,a09,1,a09:xxx,xxx
269,2023/12/1 13:00,a09,1,a09:xxx,xxx
279,2023/12/1 13:30,a09,1,a09:xxx,xxx
289,2023/12/1 14:00,a09,1,a09:xxx,xxx
299,2023/12/1 14:30,a09,1,a09:xxx,xxx
309,2023/12/1 15:00,a09,1,a09:xxx,xxx
319,2023/12/1 15:30,a09,1,a09:xxx,xxx
329,2023/12/1 16:00,a09,1,a09:xxx,xxx
339,2023/12/1 16:30,a09,1,a09:xxx,xxx
349,2023/12/1 17:00,a09,1,a09:xxx,xxx
359,2023/12/1 17:30,a09,1,a09:xxx,xxx
369,2023/12/1 18:00,a09,1,a09:xxx,xxx
379,2023/12/1 18:30,a09,1,a09:xxx,xxx
389,2023/12/1 19:00,a09,1,a09:xxx,xxx
399,2023/12/1 19:30,a09,1,a09:xxx,xxx
409,2023/12/1 20:00,a09,1,a09:xxx,xxx
419,2023/12/1 20:30,a09,1,a09:xxx,xxx
429,2023/12/1 21:00,a09,1,a09:xxx,xxx
439,2023/12/1 21:30,a09,1,a09:xxx,xxx
449,2023/12/1 22:00,a09,1,a09:xxx,xxx
459,2023/12/1 22:30,a09,1,a09:xxx,xxx
469,2023/12/1 23:00,a09,1,a09:xxx,xxx
479,2023/12/1 23:30,a09,1,a09:xxx,xxx
ファイル出力結果
MySQLに挿入
LOAD DATA LOCAL INFILE './aa10csv'
INTO TABLE sample
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'