15,050
edits
Migrate database engine from MySQL to SQLite: Difference between revisions
Jump to navigation
Jump to search
Migrate database engine from MySQL to SQLite (edit)
Revision as of 17:51, 7 November 2019
, 7 November 2019no edit summary
mNo edit summary |
No edit summary |
||
| Line 16: | Line 16: | ||
* Other functions are not supported such as: SET | * Other functions are not supported such as: SET | ||
== SQLite management software == | |||
Comparison of SQLite management softwares | |||
[https://sqlitebrowser.org/ 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 | |||
''$'' [https://www.navicat.com/cht/products/navicat-premium Navicat Premium] | |||
* Import: (1) database from SQL file (2) table from CSV/Excel file | |||
* Export: (1) database to SQL file (2) table(s) as CSV/Excel file | |||
* Export the query result: ok | |||
== References == | == References == | ||
| Line 23: | Line 37: | ||
[[Category:MySQL]] | [[Category:MySQL]] | ||
[[Category:SQLite]] | [[Category:SQLite]] | ||
[[Category:Tool]] | |||