- Install sqlite
- Coba-coba kalimat sql di sini
sqlite3 database.db
Bikin tabel, insert, dan select
create table book(title varchar(30), author varchar(30));
insert into book(title, author) values('doraemon', 'fujiko f. fujio');
insert into book(title, author) values('one piece', 'eichiro oda');
select * from book;
-- doraemon|fujiko f. fujio
-- one piece|eichiro oda
Untuk update/delete:
update book set author='dono' where title='doraemon';
delete from book where author='dono';
pip install sqlite3