使用python，操作mysql数据库

#第一步：导入pymysql第三方库

import pymysql

#连接到数据库
conn = pymysql.connect(host = "192.168.0.1",
                       port = 3306,
                       user = "python",
                       password = "123456",
                       charset = "utf8",
                        cursorclass = pymysql.cursors.DictCursor
                       )

#第二步：创建一个游标对象
cur = conn.cursor()

sql = "SELECT * FROM futureloan.member LIMIT 10"

#第三步：执行sql
res = cur.execute(sql)
print(res)

# 第四步：获取查询到的结果
# fetchone:获取查询到的一条数据
data1 = cur.fetchone()
print(data1,type(data1))

# fetchall:获取查询到的所有数据
# data2 = cur.fetchall()
# print(data2)