分类：pymysql库

2020
10-16

python pymysql库的常用操作

批量插入importpymysqldefinsert_to_mysql(to_db_list):mysql_db=pymysql.connect(host="HOST_IP",port=3306,user="username",password="password",database="db",charset="utf8")cursor=mysql_db.cursor()sql="INSERTINTO`your_db`.`your_table`(`colum1`,`colum2`,`colum3`)VALUES(%s,%s,%s)"try:#cursor.execute()cursor.executemany(sql,to_db_list)#批量插入... 继续阅读 >