python操作数据库

#!/usr/bin/env python
# -*- coding: utf-8 -*-
# @Time    : 2021/11/23 12:34 上午
# @Author  : Wayne
# @Email   : wayne@wayne.com
# @File    : month_test.py
# @Software: PyCharm
import pymysql
'''数据库操作'''
import pandas as pd
connect = pymysql.connect(host='XXXXX',port=3306,db='XXXX',user='XXX',password='XXXX')
cursor = connect.cursor()
# cursor.execute('select * from XXXXX')
data3 = pd.read_sql("select * from username",connect)

# data = cursor.fetchall()
print(data3)
data1 = cursor.fetchone()
print(data1)

print(data1[0])
# print(type(data))

# print(list(data))
cursor.close()