import pymysql
connection = pymysql.connect(host='localhost',port=3306,user='root',password='Ww#09182415',db='test04',charset='utf8')
#print(conncetion)
#获取cursor对象
cursor=connection.cursor()
#编写SQL语句
sql = 'select * from emp'
#执行SQL语句
cursor.execute(sql)
#查看结果数据集
emps = cursor.fetchall()
#print(emps,type(emps))
for e in emps:
print(e,'n')
