Jump to content

Migrate database engine from MySQL to SQLite

From LemonWiki共筆
Revision as of 17:59, 28 October 2019 by Planetoid (talk | contribs) (Created page with "== Notes == * Remove database name from SQL query: SQLite will consider the database name as table name * Replace MySQL [https://dev.mysql.com/doc/refman/8.0/en/string-functio...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Notes

  • Remove database name from SQL query: SQLite will consider the database name as table name
  • Replace MySQL CHAR_LENGTH function with SQLite Length function[1]


References

  1. ↑ sqlite does not have CHAR_LENGTH function · Issue #47 · owncloudarchive/mozilla_sync
Retrieved from "https://wiki.planetoid.info/index.php?title=Migrate_database_engine_from_MySQL_to_SQLite&oldid=20936"