??????????? view
???????????????????????洢???????select ??????????????????????????????select???view????洢????????У???????????
????create [TEMP | TEMPORARY] view ????? as select???
????select * from view_name ;
?????????View????????????????????????????
????????????????????????????????????
?????????????????????????????????????????????????
?????????????е????????????????檔
????SQLite ?????????????????????????????? DELETE??INSERT ?? UPDATE ????????????????????????????????????? DELETE??INSERT ?? UPDATE ????????????????????????????????ж??塣
??????????
?????????????????????? view_name ?? DROP VIEW ???DROP VIEW ??????????￡?
????sqlite> DROP VIEW view_name;
???????? ??????
???????????????????????????????????????
????create [temp | temporary] trigger ???????? [before | after ] [insert | update | delete | select of ????б? ] on ????
????begin
????????
????end??
??????????????????????????????????before|after?????????????????????????
?????????????????????
???????磺create table delete_log (stu_id ??name );
????create triggle delete_trig after delete on students
????begin
????insert into delete_log (stu_id ?? name) values(old.id??old.name);
????end??
???????????????????datetime(‘now’);
????????????????????old????????new
????drop????
???????????????洢????????????????????????????
????drop [table | view | index | trigger] name;
?????????????
??????????????????????е??????????????????SQL???????????У????????С?begin??commit??roolback???????
????begin
????delete from students where id = 1;
????rollback;
????rollback??????delete??б???С?
?????????????????????SQL???Ч???
????????????SQLite?????http://www.runoob.com/sqlite/sqlite-data-types.html
??????????Sqlite????????????????????????????????????????????.