1.创建一张学生表:creat table Student(
ID INTEGER ,(整型)
Name TEXT, (字符型)
Sex TEXT,
.........
primary key(ID) (以id号为关键字)
);
insert into Student values( ); 增加一条记录
update Student set Sex = ....where Name = 'zhang'; 更改名为zhang的性别
delete from Student where ID = 2; 删除一条记录
drop table Student 删除一张表
select * from Student 显示表中的所有记录