import pandas as pd
import pymysql
from sqlalchemy import create_engine
#创建一个Mysql连接器,用户名为root,密码123456
#地址为127.0.0.1,数据库名称为localhost,编码为UTF-8
# engine = create_engine('mysql+pymysql://root:123456@127.0.0.1:3306/localhost?charset=utf8')
# print(engine)
conn = pymysql.connect(host='localhost',port=3306,user='root',password='123456',db='softmodel')
formlist = pd.read_sql_query('show tables',con = conn)
print('localhost数据库数据表清单为:\n',formlist)
# sql = 'select * from 单词'
# data = pd.read_sql(sql=sql,con=conn)
# print(data)
Pycharm连接Mysql数据库
最新推荐文章于 2024-08-07 13:40:45 发布