搜索

首页  >  问答  >  正文

获取 SQL 数据时出错

<p>所以我只是从数据库中提取数据,遇到以下错误。 代码如下:</p> <pre class="brush:php;toolbar:false;">import pandas as pd import sqlalchemy engine = sqlalchemy.create_engine("mysql+pymysql://root:@localhost:3306/haider") df = pd.read_sql_table("ahmed", engine)</pre> <p>运行此代码时出现以下错误:</p> <pre class="brush:php;toolbar:false;">--------------------------------------------------------------------------- AttributeError Traceback (most recent call last) Cell In [46], line 1 ----> 1 df = pd.read_sql_table("ahmed", engine) File E:\python\lib\site-packages\pandas\io\sql.py:286, in read_sql_table(table_name, con, schema, index_col, coerce_float, parse_dates, columns, chunksize) 282 raise ValueError(f"Table {table_name} not found") 284 # error: Item "SQLiteDatabase" of "Union[SQLDatabase, SQLiteDatabase]" 285 # has no attribute "read_table" --> 286 table = pandas_sql.read_table( # type: ignore[union-attr] 287 table_name, 288 index_col=index_col, 289 coerce_float=coerce_float, 290 parse_dates=parse_dates, 291 columns=columns, 292 chunksize=chunksize, 293 ) 295 if table is not None: 296 return table File E:\python\lib\site-packages\pandas\io\sql.py:1460, in SQLDatabase.read_table(self, table_name, index_col, coerce_float, parse_dates, columns, schema, chunksize) 1417 """ 1418 Read SQL database table into a DataFrame. 1419 (...) 1457 1458 """ 1459 table = SQLTable(table_name, self, index=index_col, schema=schema) -> 1460 return table.read( 1461 coerce_float=coerce_float, 1462 parse_dates=parse_dates, 1463 columns=columns, 1464 chunksize=chunksize, 1465 ) File E:\python\lib\site-packages\pandas\io\sql.py:1003, in SQLTable.read(self, coerce_float, parse_dates, columns, chunksize) 1001 else: 1002 sql_select = select(self.table) -> 1003 result = self.pd_sql.execute(sql_select) 1004 column_names = result.keys() 1006 if chunksize is not None: File E:\python\lib\site-packages\pandas\io\sql.py:1405, in SQLDatabase.execute(self, *args, **kwargs) 1403 def execute(self, *args, **kwargs): 1404 """Simple passthrough to SQLAlchemy connectable""" -> 1405 return self.connectable.execution_options().execute(*args, **kwargs) AttributeError: 'OptionEngine' object has no attribute 'execute'</pre> <p>注意:我的数据库没有任何密码,其次我也已经安装了 PyMySQL。</p> <p>我试图解释使用 python 获取 sql 数据时遇到的错误,我希望得到该问题的解决方案。</p>
P粉648469285P粉648469285466 天前534

全部回复(1)我来回复

  • P粉781235689

    P粉7812356892023-09-05 12:12:23

    我强烈建议您尝试以下操作

    engine = sqlalchemy.create_engine("mysql+pymysql://root:@localhost:3306/haider").connect()

    我认为您可能缺少最后的 connect() 部分。

    回复
    0
  • 取消回复