'''连接数据库'''
import pymysql
def mysql():
# 连接数据库
hostvalue = 'hostvalue '
uservalue = 'uservalue '
passwordvalue = 'passwordvalue '
dbvalue = 'dbvalue '
portvalue = 3306
connection = pymysql.connect(host=hostvalue, user=uservalue, password=passwordvalue, db=dbvalue, port=portvalue,charset="utf8")
# 创建游标对象
cursor = connection.cursor()
sql = "SELECT * FROM `表名`"
# 执行语句
cursor.execute(sql)
# 处理结果
# 获取当前查询结果第一条数据
one = cursor.fetchone()
print(one,"1")
#获取当前查询结果前3条数据
many = cursor.fetchmany(3)
print(many,"2")
# 获取所有数据
all = cursor.fetchall()
print(all,"3")
# 关闭游标
cursor.close()
# 关闭数据库
connection.close()
mysql()
08-02
08-02
08-02