# 导包
#
import pymysql
# 创建链接
conn = pymysql.connect(
    host = "localhost",
    port = 3306,
    user = "root",
    password = "root",
    database = "books"

)
#
# 获取游标
cursor1 = conn.cursor()
#
# 执行sql
cursor1.execute("select version()")
result = cursor1.fetchall()       # 拿取全部数据回来
print(result)
#
# 关闭游标
cursor1.close()
#
# 关闭连接
conn.close()