Changes

Jump to navigation Jump to search
m
no edit summary
Steps of migration database engine from MySQL to SQLite == Steps of migration database engine from MySQL to SQLite == # Migrate database data from MySQL to SQLite using the SQLite management software# Modify the scripts of database access# Testing the scripts == Notes of modification of scripts ==
* Remove database name from SQL query: SQLite will consider the database name as table name
* In MySQL, string are able to quoted with single quote symbol {{kbd | key=<nowiki>'</nowiki>}} or double quote symbol {{kbd | key=<nowiki>"</nowiki>}}. In SQLite the string quoted with double quote symbol will be considered as '''column name'''! It will cause the problem: "no such column: xxx"

Navigation menu