模块对象没有属性连接
问题描述:
我已经安装了Python 2.7和mysql-python 2.7。我想执行这个代码在Python测试MySQL:模块对象没有属性连接
import MySQLdb
db = MySQLdb.connnect(host = "localhost",
user="Bishnu Bhattarai",
passwd = "password",
db = "student")
cursor =db.cursor()
cursor.execute("select * from basic_info")
numrows = int(cursor.rowcount)
for x in range(0,numrows):
row = cursor.fetchall()
print row[0],"-->",row[1]
但它显示了错误:
Traceback (most recent call last):
File "C:\Users\Bishnu\Desktop\database", line 2, in <module>
db = MySQLdb.connnect(host = "localhost",
AttributeError: 'module' object has no attribute 'connnect'
问题是什么?
答
尝试从connect
中删除第三个'n':