MYSQL to SQLite for free local

This tutorial covers bringing the data from a MYSQL database to a local SQLite database for free.
There really is no way to convert it, but instead we dump data into a file. we change the query a little to fit sqlite.
we open a terminal – connect to a sqlite db. then read the mysql dump, and it takes care of everything for us.
Then as a bonus I decided to show how to import it into an android app at the end.

links
sqlite3 app
https://www.sqlite.org/download.html

sqlitestudio
https://sqlitestudio.pl/index.rvt?act=download

github of android app example
https://github.com/Gaineyj0349/MOCKDBAPP