华清作业day34

sqlite> create table ku(numb int primary key,name char,age int,reward int);
sqlite> alter table ku add column sex char;
sqlite> insert into ku (numb , name , reward) values (1, "张三", 15000)
   ...> ;
sqlite> insert into ku (numb , name , reward) values (2, "李四", 17000);
sqlite> insert into ku (numb , name , reward) values (3, "王五", 21000);
sqlite> update ku set reward=19000 where name="张三";
sqlite> select * from ku where reward<20000 and reward>10000;
numb        name        age         reward      sex       
----------  ----------  ----------  ----------  ----------
1           张三                      19000                 
2           李四                      17000                 
sqlite> delete from ku where name="李四"
   ...> ;


sqlite> select * from ku
   ...> ;
numb        name        age         reward      sex       
----------  ----------  ----------  ----------  ----------
1           张三                      19000                 
3           王五                      21000                 
sqlite> drop table ku;


sqlite> .table
sqlite>