15,064
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 07:42, 13 November 2019
, 13 November 2019→Steps of migration database engine from MySQL to SQLite
mNo edit summary |
Tags: Mobile edit Mobile web edit |
||
| (One intermediate revision by the same user not shown) | |||
| Line 4: | Line 4: | ||
# Migrate database data from MySQL to SQLite using the [[SQLite management software]] | # Migrate database data from MySQL to SQLite using the [[SQLite management software]] | ||
# Modify the scripts of database | # Modify the scripts of database connection and SQL query syntax because some MySQL functions are not compatible in SQLite | ||
# Testing the scripts | # Testing the scripts | ||
| Line 23: | Line 23: | ||
</pre> | </pre> | ||
* Other functions are not supported such as: SET | * Other functions are not supported such as: SET, Truncate<ref>[https://www.runoob.com/sqlite/sqlite-truncate-table.html SQLite Truncate Table | 菜鸟教程]</ref>, INGORE | ||
== References == | == References == | ||