python3.7连接mysql

一.下载mysql并安装

二.使用pymysql操作数据库

import pymysql.cursors
import numpy as np
import pandas as pd

# 连接数据库
connect = pymysql.Connect(
    host='localhost',
    port=3306,
    user='root',
    passwd='123456',
    db='python',
    charset='utf8'
)

# 获取游标
cursor = connect.cursor()
#打印所有数据
cursor.execute("select * from trade")
a=list(cursor.fetchall())
b=pd.DataFrame(a,index=["one","two","three","four"],columns=["序号","姓名","联系方式","薪资","其他","备注"])
c=b.iloc[:,0:4]
print(c.sort())
cursor.close()
connect.close()