docs/html/tools/help/sqlite3.jd


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59

page.title=sqlite3
parent.title=Tools
parent.link=index.html
@jd:body

 <p>From a remote shell to your device or from your host machine, you can use the <a href= 
  "http://www.sqlite.org/sqlite.html">sqlite3</a> command-line program to manage SQLite databases
  created by Android applications. The <code>sqlite3</code> tool includes many useful commands,
  such as <code>.dump</code> to print out the contents of a table and <code>.schema</code> to print
  the SQL CREATE statement for an existing table. The tool also gives you the ability to execute
  SQLite commands on the fly.</p>

  <p>To use <code>sqlite3</code> from a remote shell:</p>

  <ol>
    <li>Enter a remote shell by entering the following command:
      <pre>adb [-d|-e|-s {&lt;serialNumber&gt;}] shell</pre>
    </li>

    <li>From a remote shell, start the <code>sqlite3</code> tool by entering the following command:
      <pre>sqlite3</pre>

      <p>You can also optionally specify a full path to a database that you want to explore.
      Emulator/device instances store SQLite3 databases in the directory 
      <code>/data/data/&lt;package_name&gt;/databases/</code>.</p>
    </li>

    <li>Once you invoke <code>sqlite3</code>, you can issue <code>sqlite3</code> commands in the
    shell. To exit and return to the adb remote shell, enter <code>exit</code> or press
    <code>CTRL+D</code>.</li>
  </ol>
  
  
      <p>Here's an example:</p>
      <pre>$ adb -s emulator-5554 shell
# sqlite3 /data/data/com.example.google.rss.rssexample/databases/rssitems.db
SQLite version 3.3.12
Enter ".help" for instructions
<em>.... enter commands, then quit...</em>
# sqlite&gt; .exit 
</pre>

  <p>To use <code>sqlite3</code> locally, instead of within a shell, 
  pull the database file from the device and start {@code sqlite3}:</p>

  <ol>
    <li>Copy a database file from your device to your host machine:
      <pre>
adb pull &lt;database-file-on-device&gt;
</pre>
    </li>

    <li>Start the sqlite3 tool from the <code>/tools</code> directory, specifying the database
    file:
      <pre>
sqlite3 &lt;database-file-on-host&gt;
</pre>
    </li>
  </ol>