Sqlite Commands in Terminal


Recently, I need to use sqlite commands to check data for my android app. Thanks to the rooted android ROM, the shell environment is much useful than before. It's possible to use Tab key to auto complete filenames and directories, and I can use sqlite3 command directly in adb shell. It saved time from pulling the database file out back and forth.

However, it's been quite a while that I almost forgot how to deal with a sqlite database. The following link is a handy Url to help me on this:


To name a few:
.mode  // select different modes, eg, list, line, column
select * from tbl1; // select all from table tbl1


Popular posts from this blog

豈止於大 -- SONY DPT-S1 不專業開箱和心得分享

Adding macros in Android Studio (Intellij) -- take Adding Javadoc comment for example

遺落境地 Eden