安装: python -m pip install pymysql (安装命令)
注意(你本地要安装好mysql并开启)
py_mysql_demo.py文件(在py_mysql目录下)
import pymysqlconfig.py (在py_mysql目录下)from py_mysql.config import dbconfig from pymysql.cursors import Cursor connection = pymysql.connect(**dbconfig) cu = Cursor(connection) # cu.executemany(sql语句) cu.executemany("""insert into nav(`name`,`nav`, `accnav`, `code`, `up_time`) values(%(name)s,%(nav)s, %(accnav)s, %(code)s, %(up_time)s) ON duplicate KEY UPDATE `up_time`=%(up_time)s,nav=%(nav)s,accnav=%(accnav)s""", src) # 如果主键(主键设置为code了)重复了,那就更新up_time,nav,accnav这些字段的数据 connection.commit() connection.close()
dbconfig = {'host': 'localhost', 'user': 'root', 'password': '', 'db': 'py_mysql', 'charset': 'utf8'}