13,298
edits
Migrate database engine from MySQL to SQLite: Difference between revisions
Jump to navigation
Jump to search
m
Migrate database engine from MySQL to SQLite (edit)
Revision as of 14:41, 9 November 2019
, 9 November 2019no edit summary
mNo edit summary |
|||
| Line 1: | Line 1: | ||
== Notes == | 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 | * 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" | * 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" | ||