コマンド履歴
状態:試行錯誤中
閲覧数:1,239
投稿日:2013-08-15
更新日:2013-08-15
Active code page: 65001
C:\Users\Administrator>adb shell
# ls
ls
config
cache
sdcard
acct
mnt
d
etc
system
sys
sbin
proc
init.rc
init.goldfish.rc
init
default.prop
data
root
dev
# cd data/data/android.style.householdaccount/databases
cd data/data/android.style.householdaccount/databases
# ls
ls
test.db
test.db2
test.db3
test.dv5
test.db5
test.db6
test.db4
test.db7
test.db8
test.db9
# sqlite3 test.db4
sqlite3 test.db4
SQLite version 3.6.22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .headers on
.headers on
sqlite> .show
.show
echo: off
explain: off
headers: on
mode: list
nullvalue: ""
output: stdout
separator: "|"
width:
sqlite> .table
.table
2013-8-9 Date_Table android_metadata
sqlite> .mode column
.mode column
sqlite> select * from Date_Table;
select * from Date_Table;
_id Item Utiwake Kingaku
---------- ---------- ---------- ----------
1 null null
2 fuku syatu 12
3 itou kazuma 123
4 null null
5 null null
6 null null
7 null null
8 null null
9 null null
10 null null
11 null null
12 null null
13 null null
14 null null
15 null null
16 null null
17 null null
18 null null
19 必須 家賃 15000
20 漫画 レース� 15000
sqlite> select * from '2013-8-9';
select * from '2013-8-9';
sqlite> .schema
.schema
CREATE TABLE '2013-8-9' (_id integer primary key,Koumoku text not null,Utiwake text,Kingaku text);
CREATE TABLE Date_Table (_id integer primary key autoincrement,Item text not null,Utiwake text,Kingaku text);
CREATE TABLE android_metadata (locale TEXT);
sqlite> .schema '2013-8-9'
.schema '2013-8-9'
CREATE TABLE '2013-8-9' (_id integer primary key,Koumoku text not null,Utiwake text,Kingaku text);
sqlite> .schema Date_Table
.schema Date_Table
CREATE TABLE Date_Table (_id integer primary key autoincrement,Item text not null,Utiwake text,Kingaku text);