python笔记--(2)--[连接MySQL]

使用pymysql连接MySQL数据库

import pymysql

conn = pymysql.connect(host="localhost", user="root", passwd="12345", db="MyDB", charset="utf-8")

cur = conn.cursor()          # 通过游标来编辑处理
cur.execute("insert into My_table(Chinese_name, English_name, Nationality) values (%s, %s, %s)",
                ("Feng Bli", "ABC", "China"))
cur.close()

conn.commit()       # 必须提交才能保存更改

conn.close()