Migrate database engine from MySQL to SQLite: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
Line 27: | Line 27: | ||
''$'' [https://www.navicat.com/cht/products/navicat-premium Navicat Premium] | ''$'' [https://www.navicat.com/cht/products/navicat-premium Navicat Premium] | ||
* Import: (1) database from SQL file (2) table from CSV/Excel file | * Import: (1) database from SQL file (2) table from CSV/Excel file | ||
* Export: (1) database to SQL file (2) table | * Export: (1) database to SQL file (2) table as CSV/Excel file | ||
* Export the query result: ok | * Export the query result: ok | ||
== References == | == References == |
Revision as of 18:00, 7 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
SQLite management software
Comparison of SQLite management softwares
DB Browser for SQLite v. 3.11.2
- Import: (1) database from SQL file (2) table from CSV file
- Export: (1) database to SQL file (2) table(s) as CSV file (3) table(s) as JSON file
- Export the query result: ok. Steps (1) execute SQL (2) click "Save the results" as CSV file
- Import: (1) database from SQL file (2) table from CSV/Excel file
- Export: (1) database to SQL file (2) table as CSV/Excel file
- Export the query result: ok