Difference between revisions of "Migrate database engine from MySQL to SQLite"
m (Planetoid moved page Migrate PHP script from SQLite to MySQL to Migrate database engine from SQLite to MySQL)
Revision as of 14:11, 1 November 2019
- 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);