【SQLite的时间差判断--删除N天前的数据的两种写法】教程文章相关的互联网学习教程文章

SQLite的时间差判断--删除N天前的数据的两种写法【代码】

表:StatisticsData CREATE TABLE "StatisticsData" ("Id" TEXT NOT NULL,"MachineName" NVARCHAR,"SessionId" INTEGER,"ProcessId" INTEGER,"ProcessName" NVARCHAR,"ProcessRunningStatus" NVARCHAR,"WorkingSetMemory" NVARCHAR,"WorkingSetPrivateMemory" NVARCHAR,"WorkingSetPeak" NVARCHAR,"ThreadCount" NVARCHAR,"HandleCount" NVARCHAR,"TotalProcessorTime" NVARCHAR,"UserProcessorTime" NVARCHAR,"Privi...