How to use SQLite3 on Android
- turn on the debug mode of your device
- connect your Android device via adb-usb-drivers of the manufactorer
- install and run your application on the device
- insert, update and delete data
- close the application, to close the database
- open the Android terminal emulator
run this, to get root permissions
$ su
go to the database directory
$ ls /data/data/com.example.app/databases
run sqlite3 and load the database
run all sql commands with (;) at the end
$ sqlite3 database.db
to get all attributes of a table, run:
$ PRAGMA table_info(tablename);
to get all tables in the database, run:
$ SELECT DISTINCT tbl_name from sqlite_master;