50 lines
1.3 KiB
MySQL
50 lines
1.3 KiB
MySQL
|
USE ybdevicev2_test
|
||
|
|
TRUNCATE TABLE cap.published
|
||
|
|
|
||
|
|
TRUNCATE TABLE cap.received
|
||
|
|
|
||
|
|
TRUNCATE TABLE dbo.YB_AdultBodyAns
|
||
|
|
TRUNCATE TABLE dbo.YB_AdultBodyResult
|
||
|
|
TRUNCATE TABLE dbo.YB_BusinessMonthData
|
||
|
|
TRUNCATE TABLE dbo.YB_Business
|
||
|
|
TRUNCATE TABLE dbo.YB_BusinessRealData
|
||
|
|
|
||
|
|
|
||
|
|
TRUNCATE TABLE dbo.YB_BusinessReportData
|
||
|
|
TRUNCATE TABLE dbo.YB_BusinessResult
|
||
|
|
TRUNCATE TABLE dbo.YB_BusinessWX
|
||
|
|
TRUNCATE TABLE dbo.YB_ChildBodyResult
|
||
|
|
|
||
|
|
DELETE FROM dbo.sys_user WHERE Phone !='18020030720'
|
||
|
|
|
||
|
|
UPDATE dbo.YB_Combined SET TodayRegCnt=0,TotalRegCnt=0,TodayResultCnt=0,TodayDevCnt=0
|
||
|
|
|
||
|
|
TRUNCATE TABLE dbo.YB_DayReport
|
||
|
|
TRUNCATE TABLE dbo.YB_DeviceDayReportData
|
||
|
|
|
||
|
|
TRUNCATE TABLE dbo.YB_Device
|
||
|
|
TRUNCATE TABLE dbo.YB_DeviceAlloc
|
||
|
|
|
||
|
|
TRUNCATE TABLE dbo.YB_EquRealData
|
||
|
|
|
||
|
|
TRUNCATE TABLE dbo.YB_Family
|
||
|
|
|
||
|
|
TRUNCATE TABLE dbo.YB_FamilyData
|
||
|
|
|
||
|
|
TRUNCATE TABLE dbo.YB_FamilyDayData
|
||
|
|
TRUNCATE TABLE dbo.YB_FamilyRealData
|
||
|
|
TRUNCATE TABLE dbo.YB_FamilyReportData
|
||
|
|
|
||
|
|
TRUNCATE TABLE dbo.YB_FamilyTarget
|
||
|
|
TRUNCATE TABLE dbo.YB_MeasureResult
|
||
|
|
TRUNCATE TABLE dbo.YB_RegUser
|
||
|
|
TRUNCATE TABLE dbo.YB_Result
|
||
|
|
TRUNCATE TABLE dbo.YB_ResultAdd
|
||
|
|
TRUNCATE TABLE dbo.YB_ScanResult
|
||
|
|
TRUNCATE TABLE dbo.YB_UserEqu
|
||
|
|
TRUNCATE TABLE dbo.YB_UserResult
|
||
|
|
TRUNCATE TABLE dbo.YB_UserSubscribeMessage
|
||
|
|
TRUNCATE TABLE dbo.YB_UserWX
|
||
|
|
TRUNCATE TABLE dbo.YB_WifiBind
|
||
|
|
TRUNCATE TABLE dbo.YB_WXFans
|