需求描述:
假设记录游戏玩家登录、退出、升级行为的日志文件表为login_table,列名为logintxt,格式示例如下:
[2023-07-01 19:46:00][login],{"id":101}
[2023-07-01 19:46:01][login],{"id":102}
[2023-07-01 19:46:01][login],{"id":103}
[2023-07-01 19:46:02][levelup],{"id":101,"to_lv":1}
[2023-07-01 19:46:02][levelup],{"id":101,"to_lv":2}
[2023-07-01 19:46:04][logout],{"id":101}
[2023-07-01 19:46:05][logout],{"id":102}
[2023-07-01 19:46:06][login],{"id":102}
[2023-07-01 19:46:07][levelup],{"to_lv":1,"id":102}
[2023-07-01 19:46:08][logout],{"id":102}
[2023-07-01 19:46:09][logout],{"id":103}
[2023-07-02 19:46:10][login],{"id":104}
[2023-07-02 19:46:11][login],{"id":101}
[2023-07-02 19:46:12][logout],{"id":101}
[2023-07-02 19:46:22][logout],{"id":104}