# 设置全部行输出
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)