完整代码:
#coding: utf-8
import pymysql
# 打开数据库连接
db = pymysql.connect("localhost","root","00000000","TESTDB" ,use_unicode=True, charset="utf8")
# 若没有 use_unicode=True, charset="utf8" 那么就会发生如题错误:
# 使用cursor()方法获取操作游标
cursor = db.cursor()
# SQL 插入语句
sql = """INSERT INTO EMPLOYEE(FIRST_NAME,
LAST_NAME, AGE, SEX, INCOME)
VALUES ('测', '试', 20, '男', 99999)"""
#db.set_character_set('utf8')