python--python操作MySQL

import pymysql

# 1. 创建连接
conn = pymysql.Connect(
    host='数据库连接地址',
    user='账号',
    password='密码',
    db='库名',
    charset='utf8',
)
print(conn)

# 2.创建游标
# 传递参数cursor=pymysql.cursors.DictCursor 返回的数据就是字典结构
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)

# 3.执行SQL语句
res = cursor.execute('select * from table order by id desc limit 10')
print(res)   # 返回影响的数据条数，或查询的条数

# 4.获取结果---默认情况下返回的是元组
one = cursor.fetchone()       # 获取一条
print(one)
three = cursor.fetchmany(3)   # 获取三条
print(three)
rest = cursor.fetchall()      # 获取所有
print(rest)

# 5.关闭游标
cursor.close()

# 6.关闭连接
conn.close()