python链接MySQL数据库。
用到MySQLdb库,安装:
pip install MySQL-python
*我这边安装完报错:error: command 'C:\\Program Files\\Microsoft Visual Studio 14.0\\VC\\BIN\\cl.exe' failed with exit status 2 (可以忽略不管)
(如果安装完 import MySQLdb 提示库不存在,可以再安装客户端库pip install mysqlclient)
查询数据库代码:
# 链接数据库
db = MySQLdb.connect("localhost", "root", "", "rudatematch_live", charset='utf8')
# 使用cursor()方法获取操作游标
cursor = db.cursor()
cursor.execute("select * from user limit 10")
results = cursor.fetchall()
for row in results:
print(row[1])