#大量导入数据进入MySQL
import pymysql
conn=pymysql.connect(host=host0,user=uid0,password=pwd0,database=db0,charset="utf8")
cur=conn.cursor()
tt='insert into kuqu(id,name,shuliang) values '
for i,a in enumerate(info_list):
temp='('+a[0]+a[1]+a[2]+')'
cur.execute(tt+temp)
i+=1
cur.close()
conn.close()
import pymysql
conn=pymysql.connect(host=host0,user=uid0,password=pwd0,database=db0,charset="utf8")
cur=conn.cursor()
tt='insert into kuqu(id,name,shuliang) values '
for i,a in enumerate(info_list):
temp='('+a[0]+a[1]+a[2]+')'
cur.execute(tt+temp)
i+=1
cur.close()
conn.close()