mysql2sqlite icon indicating copy to clipboard operation
mysql2sqlite copied to clipboard

ALTER TABLE over multiple lines produces Syntax errors

Open TobyLobster opened this issue 5 years ago • 2 comments

Hi, thanks for this nice script. Running mysql2sqlite on https://github.com/pau1ie/bbcmicro.co.uk/blob/master/db/db.sql then piping the result through sqlite3 produces syntax errors (but does convert the database more or less ok).

It looks like it's not dealing with the multiline ALTER TABLE commands (found at the end of this SQL file) properly. If I manually format each ALTER TABLE to be on a single line the script works.

TobyLobster avatar Oct 08 '18 10:10 TobyLobster

Hi @TobyLobster, thanks for the report. I'm currently still quite busy, so I'll get to this rather later. If it prevents you from using this script completely, please tell me and I'll try to accommodate my schedule.

dumblob avatar Oct 26 '18 19:10 dumblob

No worries, it's not urgent.

TobyLobster avatar Oct 26 '18 19:10 TobyLobster