SQLite DBMS 다운 및 설치, 실행

▣ SQLite DBMS

1. http://www.sqlite.org 프로그램 다운

 

 

2. 설치

압축풀면 끝!

 

3. 프로그램 실행 

 

접속 

C:\ANDROID\Android_Program\sqlite-3_6_23>sqlite3 my.db

 

Table 생성

sqlite> create table test(_id integer primary key autoincrement, name text not n
ull, addr text default 'seoul', ddate date);

 

Sample Data Insert

sqlite> insert into test(name,addr,ddate) values('test','busan',date('now'));
sqlite> insert into test(name,addr,ddate) values('hong-gil-dong','busan',date('now'));
sqlite> insert into test(name,ddate) values('lee-soon-sin',date('now'));
sqlite> insert into test(name,addr,ddate) values('han','daejeon',date('now'));

 

※ AutoCommit Default