問題描述

系統Ubuntu16，python3.5，mysql5.7Python代碼

conn = MySQLdb.connect(user='root' , passwd='123' , db='book_database' , charset='utf8')cur = conn.cursor()cur.execute('insert into book_db values(%s,%s,%s,%d)',('110','book','sxw',8))conn.commit()cur.close()conn.close()

出錯

Traceback (most recent call last): File '/home/marshalldteach/PycharmProjects/sxwpython/first.py', line 2, in <module> conn = MySQLdb.connect(user='root' , passwd='123' , db='book_database' , charset='utf8') File '/usr/local/lib/python3.5/dist-packages/MySQLdb/__init__.py', line 80, in Connect from MySQLdb.connections import Connection File '/usr/local/lib/python3.5/dist-packages/MySQLdb/connections.py', line 36 raise errorclass, errorvalue ^SyntaxError: invalid syntax

數據庫格式

desc book_db;FieldTypeNullKeyDefaultExtrabook_idchar(20)NOPRINULL book_namechar(20)YES NULL authorchar(20)YES NULL amountint(10)YES NULL

4 rows in set (0.00 sec)

在網上搜索了錯誤原因，卻沒有找到類似的問題，想請問一下這里為什么會拋出錯誤類/錯誤值，我看了一下，沒有發現問題...，希望得到大家的幫助。

問題解答

回答1：

python3 不在支持MySQLdb了。http://stackoverflow.com/ques...