Sqlite清空表数据

时间:2015-04-23 21:19:54   收藏:0   阅读:303
delete from TableName;  //清空数据
update sqlite_sequence SET seq = 0 where name =TableName;//自增长ID为0

 

原文:http://www.cnblogs.com/spadd/p/4451613.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!