sqlalchemy pandas to_sql OperationalError

Asked Jul 06 '14 at 11:23

Active Jul 06 '14 at 11:23

Viewed 885 times

I am trying to use pandas and sqlalchemy to write text files into a mysql database.

My code is:

remote_engine = create_engine('mysql://user:password@192.168.1.240/test')

table = pd.read_table('data.csv', sep=',')
table.to_sql('data', remote_engine, if_exists='append')

the if_exists flag doesn't seem to be working though I keep getting

OperationalError 1050 Table 'data' already exists.

isn't if_exists meant to cater for this?

This is using the latest version non dev version of Pandas

asked Jul 06 '14 at 11:23

KillerSnail

3,321
11
46
64

Can you show `pd.__version__`? And the output of `remote_engine.has_table('data')`? – joris Jul 06 '14 at 11:30
pd.__version__ = 0.14.0 the output of remote_engine_has_table is True – KillerSnail Jul 06 '14 at 11:48
Can you show the output of `meta = sqlalchemy.schema.MetaData(remote_engine); meta.reflect(); meta.tables.get('data')`? – joris Jul 06 '14 at 12:23
Do you still have this problem? – joris Jul 11 '14 at 10:47
I ended up just not using pandas to append to the db. But now that I have some time I can have another crack at it. – KillerSnail Jul 14 '14 at 03:22

sqlalchemy pandas to_sql OperationalError

0 Answers0

Linked