5 Star 2 Fork 10

海纳/project_1535538

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
清除用户数据.sql 1.70 KB
一键复制 编辑 原始数据 按行查看 历史
海纳 提交于 2016-09-22 16:16 . 添加
select COUNT(*) from QPAccountsDB.dbo.AccountsInfo
//---清除用户数据----------//
truncate table QPAccountsDB.dbo.AccountsInfo
truncate table QPAccountsDB.dbo.IndividualDatum
//----记录表----------//
truncate table QPRecordDB.dbo.RecordAccountsExpend
truncate table QPRecordDB.dbo.RecordConvertPresent
truncate table QPRecordDB.dbo.RecordConvertUserMedal
truncate table QPRecordDB.dbo.RecordGrantTreasure
truncate table QPRecordDB.dbo.RecordWriteGameScore
//---金币表----------------//
truncate table QPTreasureDB.dbo.GameScoreInfo
truncate table QPTreasureDB.dbo.AndroidManager
truncate table QPTreasureDB.dbo.GameScoreUpdate
truncate table QPTreasureDB.dbo.GameTask
truncate table QPTreasureDB.dbo.LivcardAssociator
truncate table QPTreasureDB.dbo.LivcardBuildStream
truncate table QPTreasureDB.dbo.OnLineOrder
truncate table QPTreasureDB.dbo.RecordDrawInfo
truncate table QPTreasureDB.dbo.RecordDrawScore
truncate table QPTreasureDB.dbo.RecordInsure
truncate table QPTreasureDB.dbo.RecordRevenRet
truncate table QPTreasureDB.dbo.RecordSpreadInfo
truncate table QPTreasureDB.dbo.RecordUserControlInfo
truncate table QPTreasureDB.dbo.RecordUserInout
truncate table QPTreasureDB.dbo.RecordUserScoreInfo
truncate table QPTreasureDB.dbo.ShareDetailInfo
truncate table QPTreasureDB.dbo.SignIn
truncate table QPTreasureDB.dbo.TakeGameGold
truncate table QPTreasureDB.dbo.TimingGift
truncate table QPTreasureDB.dbo.UserExtraInfo
//---积分表-------------//
truncate table QPGameScoreDB.dbo.AndroidManager
truncate table QPGameScoreDB.dbo.GameScoreInfo
truncate table QPGameScoreDB.dbo.GameScoreLocker
truncate table QPGameScoreDB.dbo.RecordDrawInfo
truncate table QPGameScoreDB.dbo.RecordDrawScore
truncate table QPGameScoreDB.dbo.RecordUserInout
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
C++
1
https://gitee.com/towardn/qipai2016.git
git@gitee.com:towardn/qipai2016.git
towardn
qipai2016
project_1535538
master

搜索帮助