""" -*- coding:utf-8 -*- @Time :2021/6/21 11:13 @AUTHOR :菜菜同学 @SOFTWARE : """ import pymysql # 导入模块 # 1、建立连接 conn = pymysql.connect( host="api.XXX.com", port=3306, user="用户名", password="123456", database="库名", charset="utf8" ) # 2 建立游标 cur = conn.cursor() # 3、执行sql语句 # sql = 'select * from member where mobile_phone="13566660000"' sql = 'select * from member limit 3' count = cur.execute(sql) # 返回的是,sql语句执行结果的行数 # 4、获取sql语句执行后的数据结果 one = cur.fetchone() # 获取结果当中第一条数据 print("第一条数据:",one) two = cur.fetchone() print("第二条数据:",two) all = cur.fetchone() print("所有数据:",all) # 5、关闭连接 cur.close() conn.close()
**************************************************************************************************************
# 封装到用