import pymysql
connect = pymysql.connect(host='127.0.0.1', # 本地数据库
user='root',
password='123456',
db='test',
charset='utf8') #服务器名,账户,密码,数据库名称
cur = connect.cursor()
all_sql = "select * from user order by id desc" # desc为降序,不写默认升序
cur.execute(all_sql)
datas = cur.fetchall()
print(datas)
0.连接数据库
pymysql.connect()
1.创建游标
cur = connect.cursor()
2.执行sql语句
cur.execute(sql)
3.读取执行结果
data = cur.fetchall()