【搁置待议】sqlite3迁移到mysql
相关的github项目:https://github.com/techouse/sqlite3-to-mysql
当前问题:ERROR:SQLite3toMySQL:MySQL failed creating table web_gamename: 3780 (HY000): Referencing column ‘game_id’ and referenced column ‘id’ in foreign key constraint ‘web_gamedenomination_FK_0_0’ are incompatible.
经过查看,在sqlite3中,主键都是integer类型,外键都是bigint类型。
暂时无法修改,且对数据库理解不够。暂作记录,不做深究,后续再看。