mysql2sqlite icon indicating copy to clipboard operation
mysql2sqlite copied to clipboard

Timestamp rows not ported correctly

Open emaccheese opened this issue 3 years ago • 1 comments

row with a timestamp from MySQL dump file, : " dateCreated timestamp NULL DEFAULT current_timestamp(),"

These cause syntax errors when trying to read the sqlite result. I believe correct way should be "Timestamp dateCreated DEFAULT CURRENT_TIMESTAMP,"

emaccheese avatar Feb 04 '22 00:02 emaccheese

Thank you! This looks like a bug.

PRs welcome. Otherwise I hope to fix this sometime in the future.

ww9 avatar Sep 24 '24 09:09 ww9