config = {
"host": "", # Mysql server Ip
"user": "", # Mysql table users user
"password": "", # Mysql user password
"database": "" # Mysql database name
}
创建数据库连接
db = pymysql.connect(**config)
获取游标对象
cursor = db.cursor()
使用execute执行sql语句
cursor.execute("select databases")
获取执行后的数据
fetchone 方法是获取第一条数据返回一个一维元组
fetchall 方法是获取全部数据返回一个二维元组
fetchone
data = (cursor.fetchone())
print(type(data))
print(data)
fetchall
data = (cursor.fetchall())
print(type(data))
print(data)