====9月16
------创建数据库test
dos界面运行 sqlite.exe test.db3
------创建表courses
create table courses
(
cno varchar(10) not null,
cname varchar(32),
credit decimal(2,1)
);
------插入数据
insert into courses (con,cname) values ('01','the first'),('02','the second');
------删除数据
delete from courses where cno='01';
------查看数据
select * from courses;
------修改数据
update courses set cname='new name' where cno='01';
------strftime
select strftime('%Y',birthday) from students where sname='高平'
------insert
插入一行:
insert into table values('05','e','90');
插入多行:
insert into tablename (select sno,'f',60 from students);(插入了student里面的所有sno)
------delete删除
delete [from] table where sn0='01';
------update修改
update courses set cname='new name' where cno='01';