Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>d:
D:\>sqlite3 test1.db
SQLite version 3.6.16
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
sqlite> create table TTT(seq INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT not nul
l, addr TEXT, date DATE );
sqlite> .tables
TTT
sqlite> select * from TTT;
sqlite> insert into TTT (name, addr, date) values('jeniffer','seoul',date('now'));
sqlite> select * from TTT;
1|jeniffer|seoul|2010-02-24
sqlite> insert into TTT(name, addr, date) values('suru','seoul', date('now'));
sqlite> insert into TTT(name, addr, date) values('nancy','seoul' date('now'));
SQL error: near "date": syntax error
sqlite> insert into TTT(name, addr, date) values('nancy','seoul', date('now'));
sqlite> select * from TTT;
1|jeniffer|seoul|2010-02-24
2|suru|seoul|2010-02-24
3|nancy|seoul|2010-02-24
sqlite>
======================================================================================
디비 생성후 접근
D:\>adb -s emulator-5554 shell
# sqlite3 /data/data/android.data.db.databases/testDB.db
sqlite3 /data/data/android.data.db.databases/testDB.db
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> .databases
.databases
sqlite> .quit
.quit
# sqlite3 /data/data/android.data.db/databases/testDB.db
sqlite3 /data/data/android.data.db/databases/testDB.db
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> .databases
.databases
seq name file
--- --------------- ----------------------------------------------------------
0 main /data/data/android.data.db/databases/testDB.db
sqlite> .table
.table
ADDRESS android_metadata
sqlite> select * from ADDRESS;
select * from ADDRESS;
1|test|test|2010-02-24
2|test1|test1|2010-02-24
4|test3|test3|2010-02-24
sqlite>
