Migrate database engine from MySQL to SQLite

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
  • Replace MySQL CHAR_LENGTH function with SQLite Length function
  • Replace MySQL IF function with SQLite CASE function
  • Replace MySQL LOCATE function with SQLite INSTR CASE function

-- MySQL
LOCATE(substr,str), LOCATE(substr,str,pos)

-- SQLite
INSTR(string, substring);

• Other functions not supported: SET