adb shell command---SQLite

 

输入adb shell，提示device not found？

请注意，你的模拟器打开了吗？打开模拟器，就OK了。

# mkdir databases

# chmod 777 databases
# ls -l
drwxrwxrwx root     root              2011-02-21 16:39 databases
drwxr-xr-x system   system            2011-02-21 15:54 lib
# cd databases
# sqlite3 notes.db
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> sqlite3 notes.db
   ...> create table notes
   ...> (_id integer primary key,
   ...> note text not nul,
   ...> created integer);
SQL error: near "sqlite3": syntax error
sqlite> create table notes         
   ...> (id integer primary key,
   ...> note text not null,
   ...> created integer);
sqlite>

 

.tables .databases .schema

 

.help

 

.exit

 

sqlite3 notes.db