#coding:utf-8
import pymysql
import datetime
#创建数据库连接
connection = pymysql.connect("localhost","root","123123","test")
# 创建 cursor
cursor =connection.cursor()
sql="select * from emp"
#cursor执行sql
cursor.execute(sql)
# 获取cursor执行sql之后第一行结果
emp = cursor.fetchall()
print(type(emp))
print(type(emp[4]))
# 关闭游标 和连接
cursor.close()
connection.close()