1.显示已经创建的数据库 xxx.db:
.database
2.每条语句都要以;号结束:
.select * from mytable;
3.创建一个张表并向表中插入数据:
.create table mytable(one varchar(10),two smallint);
.insert into mytable values('hello',10);
.insert into mytable values('googby',20);
4.还有一种插入方式:
.creaet table mytable(id interger Primary key,value text);
.insert into mytable(id,value) values(1,'micheal');
.insert into mytable(id,value) values(2,'jenny');
5.删除某一条记录:
delete from mytable where id=1;
6.更新表单中某条记录的值:
update mytable set value='zhucz' where id=2;
7.添加一个字段:
.timer on
alter table mytable add column address varchar(20);
8.删除一张表单
.drop table mytable;