MySQL2.python pymysql链接MySQL数据库

导入pymysql模块
import pymysql
#链接数据库
conn = pymysql.connect(host=‘localhost’,user=‘root’,password=‘123456’,database=‘dbmovie_top250’,port=3306,autocommit=False)
#获取游标
cursor = conn.cursor()
#执行sql
cursor.execute(‘select * from t_top250;’)
result = cursor.fetchall()
for i in result:
print(i)
conn.commit()
cursor.close()
conn.close()

(1, ‘肖申克的救赎’, ‘1994’, ‘9.7’, ‘1.png’, ‘2408347’)
(2, ‘霸王别姬’, ‘1993’, ‘9.6’, ‘2.png’, ‘1792424’)
(3, ‘阿甘正传’, ‘1994’, ‘9.5’, ‘3.png’, ‘1812812’)
(4, ‘这个杀手不太冷’, ‘1994’, ‘9.4’, ‘4.png’, ‘1981232’)
(5, ‘泰坦尼克号’, ‘1997’, ‘9.4’, ‘5.png’, ‘1774115’)
(6, ‘美丽人生’, ‘1997’, ‘9.6’, ‘6.png’, ‘1112166’)