mysql2sqlite
mysql2sqlite copied to clipboard
ALTER TABLE over multiple lines produces Syntax errors
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.
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.
No worries, it's not urgent.