我想使用to_sql函数将数据写入到MariaDB数据库中。PyCharm中的Python代码如下所示:import mysql.connector在执行控制台中的最后一行时,我会得到以下错误:
Error on sql SELECT name FROM sqlite_master WHERE type='table' AND name='
我正试着用to_sql方法把我的DataFrame写到雪花上。File "/home/karma/.local/lib/python3.6/site-packages/pandas/io/sql.py", line 1584, in executeAttributeError: 'SnowflakeCursor' object has no
sep='|', names=fields, skiprows=i, nrows=div, encoding='latin-1') del df
# We can use the pandas.to_sql command to put the data in our SQLlite database:
df.to_sql("main", sqlite_engine,
这是我的密码。import sqlite3
df = pandas.read_csv('testcsv.csv')这是我得到的错误,即使在我安装sqlalchemy之后,因为它抱怨它没有安装。\venv\lib\site-packages\pandas\io\sql.py", line 503, in <