mysql2sqlite

mysql2sqlite copied to clipboard

Missing ' \( ' in ' enum ' replacement

2

The missing ` \( ` did break our schema with column name `print_seitenumbruch`. The string contains `enum` that got replaced to `print_seittext NOT NULL DEFAULT 0'`.

cspiegel-zepf

Invalid extra comma for CREATE TABLE with CONSTRAINT

3

Original: ```sql CREATE TABLE "test1" ( "id" bigint(20) unsigned NOT NULL AUTO_INCREMENT, "match_id" bigint(20) unsigned NOT NULL, "season_id" int(11) unsigned DEFAULT NULL, "date" datetime DEFAULT NULL, PRIMARY KEY ("id"), UNIQUE...

ml31415

Converting trigger -- Parse error near near "IF"

3

I have several triggers which in MySQL dump look like this: ``` DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `check_zero_prefs` BEFORE INSERT ON `lang_prefs` FOR EACH ROW BEGIN IF...

macias

Fails to convert libgen_compact.sql

1

Data source is `libgen_compact.sql` from one of the `libgen_compact*.rar` archives that can be found here: https://data.library.bz/dbdumps/ I get this error running the command: ```sh ❯ ./mysql2sqlite/mysql2sqlite libgen_compact.sql | sqlite3 libgen_compact_20230606.db...

redthing1

This MySQL query for creating a table: ```sql CREATE TABLE IF NOT EXISTS appointment_service_type ( appointment_service_type_id INT NOT NULL AUTO_INCREMENT , appointment_service_id INT NOT NULL, name VARCHAR(50) NOT NULL ,...

pgregorio-signalytic