mysql
qyykaola
这个作者很懒,什么都没留下…
展开
-
Python批量插入mysql(通过TXT文件)
from conf import settingimport pymysql#链接数据库conn = pymysql.connect(host=setting.MYSQL_HOST, user=setting.USER, password=setting.PASSWORD, port=settin...转载 2018-11-15 17:11:20 · 1312 阅读 · 0 评论 -
python操作mysql批量插入数据(通过for循环方式)
import pymysqlconn =pymysql.connect(host='meixin-mysql-one.pre.cloud.db',user='video_adminu',passwd='ogEGcJq4RLOu',db='video_auction',port=5309,charset='utf8')cur =conn.cursor()count = 0while cou...转载 2018-11-15 17:13:18 · 9093 阅读 · 0 评论