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。。。
你好,能提供一下报错代码吗?
权限没放开?