Read the scheduler: 0%| | 0/500001 [00:00<?, ?it/s]
Read the scheduler: 76%|█████████████▋ | 380000/500001 [01:02<00:13, 8921.37it/s]
Write db Scheduler: 96%|██████████████████████████▉ | 26/27 [01:13<00:01, 1.10s/it]
Write db Scheduler: 100%|████████████████████████████| 27/27 [01:13<00:00, 1.16it/s]
'finish'
读表生成csv
sql='''select * from student where SNO<2000000'''path='/home/test.csv'to_db=create_engine("mysql+pymysql://root:123456@localhost:3306/aps_2")
fast_sql.to_csv(sql,con,path_or_buf=path,show_progress=True,index=None)