Opening Sqlite Db on command prompt

Question

Friend , I working on Sqlite DB,i want to open and view or create database through adb shell command.. in command prompt i'm doing this above steps, 1. cd C:\android-sdk_r04-windows\android-sdk-windows\tools> 2.adb shell how can i go for sqlite> after step2 and i'm getting an $ after step 2 and then how can move further process. suppose i want to view database means how can i do it. i given cd/data/data/(mypackage)/databases sqlite3 (database)... after $ but it shows database not found.... How can i view database executed through my code... anybody help me to get it.

Thanks in advance.

Answer 1

You can use sqlite3 command to connect to database from adb shell. Find example here This will open an sql prompt where you can execute standard commands supported. Another link which explains creating a database, creating table and viewing its contents all from command prompt (adb shell) is here.