1.pip3 install pymysql
2.安装成功后,import pymysql
3.连接数据库,conn=pymysql.connect(host=‘数据库地址’,user=‘用户名’,passwd=‘密码’,db=‘库名’)
4.创建游标,cur = conn.cursor()返回值为
cur=conn.cursor(pymysql.cursors.DictCursor)返回为值为字典
5.sql语句,sql = “select * from quote_basic where type=11 and sub_type=‘3’” 查看表结构,注意查询的字段类型,避免报错;
6.执行sql语句,cur.execute(sql)
7.获取数据,data = cur.fetchall()
完整代码:
def __init__(self):
conn = pymysql.connect(host='',user='',passwd='',\
db='')
cur = conn.cursor()
sql = "select * from quote_basic where type=11 and sub_type='3'"
cur.execute(sql)
data = cur.fetchall() # 通过fetchall()方法获取数据
print(data)