소개 및 기초 CRUD

> sqlite3

sqlite> .open mydatabase
sqlite> create table if not exists books (
   ...> book_id integer primary key autoincrement,
   ...> name char(100) not null,
   ...> author char(100) not null,
   ...> updatedate datetime
   ...> );

sqlite> .schema books
create table books(
    book_id integer primary key autoincrement,
    name char(100) not null,
    author char(100) not null,
    updatedate datetime
);

sqlite> insert into books(name,author,updatedate) 
   values('영어회화100일의기적', '신달수', datetime('now'));

sqlite> select * from books;
sqlite> select name,author from books where name like '%영어%';
sqlite> select * from books order by name asc;
sqlite> select * from books order by name desc;

sqlite> update books set name='수정영어교재' where book_id=4;
sqlite> delete from books where name='수정영어교재'

sqlite> select count(*) from books;
sqlite> select max(book_id) from books;