etlalchemy icon indicating copy to clipboard operation
etlalchemy copied to clipboard

Published 20 hours ago • verified publisher icon seanharr11

"Upserting" to MySQL doesn't work

Open tonyyao81 opened this issue 7 years ago • 2 comments
trafficstars

When drop_database=False, real sql statements get dumped to file but it's imported by mysqlimport. That ends up in inserting the whole statement into the first column of the table. Is it a known issue or a non supported feature?

tonyyao81 avatar Apr 08 '18 14:04 tonyyao81

Interesting...this feature (upserting) was a bit experimental, but this sounds like an easy enough fix. I've really only tested this on PostgreSQL, so it may be that MySQL behavior is iffy. Would you be willing to take a stab at fixing this with a Pull Request?

seanharr11 avatar Apr 11 '18 01:04 seanharr11

sure, will do.

tonyyao81 avatar Apr 18 '18 07:04 tonyyao81