python操作mysql

import pymysql

connect_obj = pymysql.connect(host='localhost',
                              port=3306,
                              database='python',
                              user='root',
                              password='123456',
                              charset='utf8')
print(connect_obj)

# 获取可操作对象pymysql.cursors.DictCursor
cur = connect_obj.cursor()

# 原生sql语句
sql = 'select * from student'

# 返回记录条数
count = cur.execute(sql)
# print(count)

# 查询操作
data = cur.fetchone()
print(data)