Re: [sqlite] mysql -> sqlite problem

2019-12-19 Thread Jens Alfke
> On Dec 19, 2019, at 4:49 PM, Mike Bentley wrote: > > Is it true that "Each index name must be unique in the database"? Yes. You're right that the docs don't seem to spell this out, but since the syntax to delete an index is "DROP INDEX ", you couldn't have multiple indexes with the same

[sqlite] mysql -> sqlite problem

2019-12-19 Thread Mike Bentley
I used two different mysql to sqlite conversion tools to do test conversions. One tool is written in python and is called mysql-to-sqlite, and the other in awk called mysql2sqlite, both available via github. The one in python ran into an error and stopped very early in the process. The one