更新表中记录
sqlite> update staff set age=age+10; sqlite> select * from staff; 2014001|马化腾|13 2014002|马云|14 2014003|李彦宏|16 2014004|胡夸风|16 2014006|窦思涡|21 sqlite> select * from staff where age < 15; 2014001|马化腾|13 2014002|马云|14 sqlite> update staff set age=age+10 where age < 15; sqlite> select * from staff; 2014001|马化腾|23 2014002|马云|24 2014003|李彦宏|16 2014004|胡夸风|16 2014006|窦思涡|21 sqlite>
sqlite> select * from staff; 2014001|马化腾|23 2014002|马云|24 2014003|李彦宏|16 2014004|胡夸风|16 2014006|窦思涡|21 2014113|will delete|23 sqlite> delete from staff where NO='2014113'; sqlite> select * from staff; 2014001|马化腾|23 2014002|马云|24 2014003|李彦宏|16 2014004|胡夸风|16 2014006|窦思涡|21 sqlite>