~_~ python读取数据库错误!!我实在是找不到问题在哪里了

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

mysql_config = {'host': '59.78.102.118',
                'port': 23208,
                'user': 'student',
                'password': 'Python_123456',
                'dbname': 'research'}
mysql_engine = create_engine('mysql+pymysql://student:Python_123456@59.78.102.118:23208/research'.format(**mysql_config), pool_pre_ping=True)

sql = "select Date,Close from stock trading date where Date >= '2005-01-01' AND Date <= '2018-12-31' AND Stkcd = '000041'"
pd_data = pd.read_sql(sql,mysql_engine)
print(pd_data)

select Date,Close from stock trading date where Date >= '2005-01-01' AND Date <= '2018-12-31' AND Stkcd = '000041'
从报错看,应该是这句查询语句错了,然后select Data,Close(这是属性) from stock trading data(这3个单词应该是表吧,你看下表的名称具体是什么,应该不是这么写的,至少应该是有下划线什么的连起来的) where。。。

你好,能提供一下报错代码吗?

权限没放开?