#!/usr/bin/python3
# -*- coding:utf-8 -*-
import pymysql
coon = pymysql.connect(host='localhost', user='root', password='123', port=3306, db='liss',)
cur = coon.cursor()
cur.execute("select * from userlist;")
res = cur.fetchall()
print (res)
cur.close()
coon.close()
如图，执行代码查到三条数据
