代码如下
#!/usr/bin/env python
# -*- coding:utf-8 -*-
# Author:lcj
import pymysql
#连接数据库
conn = pymysql.connect(host='172.26.11.46',port= 3306,user = 'root',passwd='123456',db='mytest_db')
#创建游标
cur = conn.cursor()
#插入一条数据
# reCount = cur.excute('insert into lcj(name,age) vaules(%s,%s)',('ff',18))
#向test库中的lcj表插入
# ret = cur.executemany("insert into lcj(name,tel)values(%s,%s)", [("kk",13212344321),("kw",13245678906)])
#同时向数据库lcj表中插入多条数据
#ret = cur.executemany("insert into lcj values(%s,%s,%s,%s,%s)", [(41,"xiaoluo41",'man',24,13212344332),(42,"xiaoluo42",'gril',21,13245678948),(43,"xiaoluo43",'gril',22,13245678949),(44,"xiaoluo44",'main',24,13543245648)])
#提交
conn.commit()
#关闭指针对象
cur.close()
#关闭连接对象
conn.close()
#打印结果
print(ret)
错误如下：
File "aadd.py", line 6, in
conn = pymysql.connect(host='172.26.11.46',port= 3306,user = 'root',passwd='123456',db='mytest_db')
File "/usr/local/lib/python3.4/dist-packages/PyMySQL3-0.5-py3.4.egg/pymysql/__init__.py", line 93, in Connect
File "/usr/local/lib/python3.4/dist-packages/PyMySQL3-0.5-py3.4.egg/pymysql/connections.py", line 510, in init
File "/usr/local/lib/python3.4/dist-packages/PyMySQL3-0.5-py3.4.egg/pymysql/connections.py", line 676, in _connect
File "/usr/local/lib/python3.4/dist-packages/PyMySQL3-0.5-py3.4.egg/pymysql/connections.py", line 830, in _get_server_information
File "/usr/local/lib/python3.4/dist-packages/PyMySQL3-0.5-py3.4.egg/pymysql/charset.py", line 173, in charset_by_id
File "/usr/local/lib/python3.4/dist-packages/PyMySQL3-0.5-py3.4.egg/pymysql/charset.py", line 21, in by_id
KeyError: 46
求大神指导
