python数据库

import numpy as np
import pandas as pd
import matplotlib.pylab as plt
import mysql.connector
conn = mysql.connector.connect(host='localhost',
                        user='root',
                        passwd='root',
                        db='1234')#链接本地数据库
sql = 'select * from yinong'#sql语句
data = pd.read_sql(sql,conn)#获取数据
print(data)