C:\>
sqlite3 mydatabase.db
sqlite> create table user(id integer,username text,password text);
sqlite> insert into user values(1,'king','king');
sqlite> select * from user;
sqlite> update user set username='kong',password='kong' where id=1;
sqlite> delete from user where username='kong';
