15,050
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:13, 1 November 2019
, 1 November 2019no edit summary
m (Planetoid moved page Migrate database engine from SQLite to MySQL to Migrate database engine from MySQL to SQLite without leaving a redirect) |
mNo edit summary |
||
| Line 1: | Line 1: | ||
== Notes == | == Notes == | ||
* 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 or double quote symbol. 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" | ||
* Replace the following functions | * Replace the following functions | ||
** Replace MySQL [https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_char-length CHAR_LENGTH] function with SQLite [https://www.sqlitetutorial.net/sqlite-functions/sqlite-length/#targetText=SQLite%20Length,returns%20the%20number%20of%20bytes. Length] function<ref>[https://github.com/owncloudarchive/mozilla_sync/issues/47 sqlite does not have CHAR_LENGTH function · Issue #47 · owncloudarchive/mozilla_sync]</ref> | ** Replace MySQL [https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_char-length CHAR_LENGTH] function with SQLite [https://www.sqlitetutorial.net/sqlite-functions/sqlite-length/#targetText=SQLite%20Length,returns%20the%20number%20of%20bytes. Length] function<ref>[https://github.com/owncloudarchive/mozilla_sync/issues/47 sqlite does not have CHAR_LENGTH function · Issue #47 · owncloudarchive/mozilla_sync]</ref> | ||