[Android]_ch8.17_利用SQLite3建立資料庫

[Android]_ch8.17_利用SQLite3建立資料庫

C:\Gjun135>sqlite3 YPU.db

SQLite version 3.8.6 2014-08-15 11:46:33

Enter ".help" for usage hints.

sqlite> CREATE TABLE teacher (id TEXT,name TEXT,phoneNo TEXT,address TEXT);

sqlite> .table

teacher

sqlite> .schema

CREATE TABLE teacher (id TEXT,name TEXT,phoneNo TEXT,address TEXT);

sqlite> SELECT * FROM teacher;

sqlite> INSERT INTO teacher VALUES ('1','Derek','0911-111111','Taipei');

sqlite> INSERT INTO teacher VALUES ('2','Merry','0922-222222','Taipei');

sqlite> INSERT INTO teacher VALUES ('3','Tom','0933-333333','Taichung');

sqlite> INSERT INTO teacher VALUES ('4','Bob','0944-444444','Hsinchu');

sqlite> INSERT INTO teacher VALUES ('5','Jerry','0955-555555','Hsinchu');

sqlite> SELECT * FROM teacher;

1|Derek|0911-111111|Taipei

2|Merry|0922-222222|Taipei

3|Tom|0933-333333|Taichung

4|Bob|0944-444444|Hsinchu

5|Jerry|0955-555555|Hsinchu

sqlite> SELECT id,name,address FROM teacher WHERE address='Hsinchu' ORDER by id;



4|Bob|Hsinchu

5|Jerry|Hsinchu



sqlite> SELECT id,name,address FROM teacher ORDER by name;

4|Bob|Hsinchu

1|Derek|Taipei

5|Jerry|Hsinchu

2|Merry|Taipei

3|Tom|Taichung



sqlite> UPDATE teacher SET address='Hsinchu' WHERE name='Tom';

sqlite> SELECT id,name,address FROM teacher ORDER by name;

4|Bob|Hsinchu

1|Derek|Taipei

5|Jerry|Hsinchu

2|Merry|Taipei

3|Tom|Hsinchu