以下的是我的数据表结构
#coding:utf-8
import pymysql
import pymysql.cursors
connection = pymysql.connect(host='127.0.0.1',
user='root',
password='root',
db='test',
port=3306,
charset='utf8') # 注意是utf8不是utf-8
try:
with connection.cursor() as cursor:
cursor.execute("SET NAMES utf8")
sql_1 = 'select * from user'
cout_1 = cursor.execute(sql_1)
print("目前数量: " + str(cout_1))
for row in cursor.fetchall():
print("id:", str(row[0]), 'name', str(row[1]), 'age', str(row[2]))
sql_2 = 'insert into user(name,age,sex) value("什么鬼",26,1)'
cout_2 = cursor.execute(sql_2)
print("插入的数量: " + str(cout_2))
connection.commit()
finally:
connection.close()