Difference between revisions of "Migrate database engine from MySQL to SQLite"

From LemonWiki共筆
Jump to: navigation, search
m
m
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
    • Replace MySQL CHAR_LENGTH function with SQLite Length function[1]
    • Replace MySQL IF function with SQLite CASE function[2]
    • Replace MySQL LOCATE function[3] with SQLite INSTR CASE function[4]
-- MySQL
LOCATE(substr,str), LOCATE(substr,str,pos)

-- SQLite
INSTR(string, substring);
  • Other functions are not supported such as: SET

References