How to create sqlite tables from mysql

Question

MySQL

I am working on a small guide for android. The web version of the reference works with several mysql tables. Tell me how to drive these mysql tables into android in sqlite? And how to update them in the future from the application?

Answer 1

Thank you, the solution is clear. And there is an example solution for subsequent updates from the head database.

Answer 2

If the volume is small and the tables are the simplest, I would simply dump it into sql code, which I would then execute in the sqlite database.

Answer 3

there are many records there
are 5 thousand
there are 11 thousand

Answer 4

www.chillitalks.com/page/besplatnyj-i-bystryj-mysql-sqlite-konverter/
www.sqlite.org/cvstrac/wiki?p=ConverterTools

Answer 5

There is such a thing as taps: github.com/ricardochimal/taps
Mn helped a lot to transfer redmine's database.
However, I do not know if it is possible to transfer the database from a computer to an android.