http://blog.csdn.net/lishan9133/article/details/70249 之前是按照上面的教程安装了mysqldb模块,可是在实际操作过程中,找不到对应行的代码,所以并没有按照上面的改。 打开数据库连接 db = MySQLdb.connect( host='192.188.80.41', port=3306, user='r
http://blog.csdn.net/lishan9133/article/details/70249
之前是按照上面的教程安装了mysqldb模块,可是在实际操作过程中,找不到对应行的代码,所以并没有按照上面的改。
db = MySQLdb.connect(
host='192.188.80.41',
port=3306,
user='root',
passwd='123456',
db='db_zhuanjia',
charset='utf8')
cursor = db.cursor()
sql = """ INSERT INTO EMPLOYEE(Sex)
VALUES (ans2(1))"""
try:
# 执行sql语句
cursor.execute(sql)
# 提交到数据库执行
db.commit()
except:
# Rollback in case there is any error
db.rollback()
db.close()
报错代码:
Traceback (most recent call last):
File "G:\python\1\craweler2.py", line 44, in
charset='utf8')
File "G:\python\1\lib\site-packages\MySQLdb__init__.py", line 80, in Connect
return Connection(*args, **kwargs)
File "G:\python\1\lib\site-packages\MySQLdb\connections.py", line 187, in init
super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (2003, "Can't connect to MySQL server on '192.188.80.41' (10060)")
Copyright © 2019- baomayou.com 版权所有 赣ICP备2024042794号-6
违法及侵权请联系:TEL:199 18 7713 E-MAIL:2724546146@qq.com
本站由北京市万商天勤律师事务所王兴未律师提供法律服务