Migrate database engine from MySQL to SQLite: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
Line 15: | Line 15: | ||
</pre> | </pre> | ||
* Other functions not supported: SET | * Other functions are not supported such as: SET | ||
== References == | == References == |
Revision as of 18:53, 6 November 2019
Notes
- 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"
- Replace the following functions
-- MySQL LOCATE(substr,str), LOCATE(substr,str,pos) -- SQLite INSTR(string, substring);
- Other functions are not supported such as: SET