【sqlalchemy报错】ObjectNotExecutableError: Not an executable object: 'select * from 表名'

Question

import pandas as pd
from sqlalchemy import create_engine
import numpy as np
import pymysql 

#链接数据库
engine = create_engine('mysql+pymysql://root:woshihby0.@localhost/study?charset=UTF8MB4')    
#输出数据
df.to_sql('表名', conn, if_exists='append' ) #如果表名存在则在后面添加数据
#读写
connection = engine.connect()
sql = 'select * from 表名' #查询语法
df3 = pd.read_sql(sql = sql, con = connection )

报错如下：ObjectNotExecutableError: Not an executable object: 'select * from 表名'

Answer 1

试试这个链接的解决方案呗
https://blog.csdn.net/weixin_41986134/article/details/129137460