Built-in SQLite database Operation DOS command from Android

1: What's called SQLite database

Android system kernel is a Linux system, Android system is very special, he brought a SQLite database, lightweight type of an embedded database

It occupies very low resources , in the embedded device, may only need hundreds of K of memory is enough. Easy to operate, if you've learned the basics of other databases before,

Operation can be said to be a lift.

2: What is the data type of this SQLite database?　

Integer integer signed integer -1,0,1,2,3 ...

The Real float is stored in 8-byte IEEE floating-point numbers.

Text. The value is a text string that is stored using the database encoding (UTF-8, utf-16be, or Utf-16le).

Blob. The value is a block of data that is stored as it is entered. A binary type stores the past.

3: Let's get started, the eclipse device is connected to the emulator, or the "real" phone.
3.1: Open dos command, cmd--->cd xxxxxxx----------> Enter the directory where your SDK development environment is located.
Sdk\platform-tools the directory where this folder is located.

(Detection: Adb.exe can run normally)

3.2: After entering in the previous step, test ADB devices shows the device (emulator or real phone) that is currently being successfully connected by Eclipse development Android

3.2: Test access to Android database Kernel command

ADB shell

If it is displayed # indicates that you are currently gaining access to the Android system's highest privilege administrator

If it is displayed, $ indicates that the normal permissions

3.3 Common DOS commands for SQLite

ls---> list displays the contents of the current folder

Sqlite3 settings.db---> command into the SQLite operator interface

. tables-View All tables

SELECT * from XX table name; ---> Query is Data with no fields.

. Header on---> Set table for display field names

. Help---> This command lets us see a lot of commands

. mode column---> Query data are typeset, clear and unambiguous.

Built-in SQLite database Operation DOS command from Android