Sqlite????????
???????????? ???????[ 2016/8/23 9:43:02 ] ????????????? SQLite
??????????? 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????????????????????????????????????????????.
???????????????????????漰???????????????????SPASVOС??(021-61079698-8054)?????????????????????????
??????
?????????????????????????Щ????????????????????TC???????????????Щ???????????????????????????????????????????????(java .net ?????)???mysql???????????????????ж????д???Python???????????????(DB2)??????BufferPool????????????????????????????????6??????????????????滮???????????????-????????SQL Server???????????????????λ?????PHP??SQL????????????????????Pythonд???NoSQL????????? SQL ?е????????????? SQL ?е?????????Java???????:?????MySQL???????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11????????
?????????App Bug???????????????????????Jmeter?????????QC??????APP????????????????app?????е????????jenkins+testng+ant+webdriver??????????????JMeter????HTTP???????Selenium 2.0 WebDriver ??????