# 设置全部行输出
from IPython.core.interactiveshell import InteractiveShell
InteractiveShell.ast_node_interactivity = "all"

# 1.安装pymysql https://pypi.org/project/PyMySQL

pip install pymysql -i https://pypi.douban.com/simple

#2.导包

import pymysql

#3.创建链接对象

mydb = pymysql.connect(

host = 'localhost',

user = 'root',

password = '1234',

database = None,

port = 3307,

charset = 'utf8'

)

# 4.创建游标对象，这里创建的游标是可以返回字段名的字典比较好用

mycursor = mydb.cursor(cursor = pymysql.cursors.DictCursor)

#5.调用游标对象的execute()方法执行sql语句

conn.commit() #提交事务

#查询结果的释放 cur.close(),conn.close()

#建议直接转变成DataFrame好

import pandas as pd

pd.DataFrame(mycursor)