首页 > 专利信息

删除数据的sql语句

truncate table

--删除单个站点的相关数据【只删除数据，不删除基本信息】

--总表

DELETE FROM [In_Port_Log] where Hardware_Id=''

DELETE FROM [In_Port_LogError] where Hardware_Id=''

--降雨

DELETE FROM [HY_OBP_G] where STCD = '' --降雨记录表

DELETE FROM [ST_PPTN_R] where STCD = '' --降雨处理表

DELETE FROM [HY_DP_C] where STCD = '' --降雨日记录

DELETE FROM [HY_MTP_E] where STCD = '' --降雨月纪录

DELETE FROM [HY_YRP_F] where STCD = '' --降雨年纪录

DELETE FROM [Ep_YQ_JC] where STCD = '' --预警

DELETE FROM [LH_P_R] where STCD = '' --实时表

DELETE FROM [LH_P_DAY] where STCD = '' --降雨统计表：日表

DELETE FROM [LH_P_MONTH] where STCD = '' --降雨统计表：月表

--流量

DELETE FROM [ST_RIVER_R] where STCD = '' --河道处理表

DELETE FROM [HY_DQ_C] where STCD = '' --流量日记录

DELETE FROM [HY_MTQ_E] where STCD = '' --流量月纪录

DELETE FROM [HY_YRQ_F] where STCD = '' --流量年纪录

DELETE FROM [LH_Q_DAY] where STCD = '' --河道统计表：日表

DELETE FROM [LH_Q_MONTH] where STCD = '' --河道统计表：月表

DELETE FROM [LH_Q_DAY_MinMaxAvg] where STCD = '' --河道统计表：最大最小值表 --库容

DELETE FROM [ST_RSVR_R] where STCD = '' --库容处理表

DELETE FROM [HY_DV_C] where STCD = '' --库容日记录

DELETE FROM [HY_MTV_E] where STCD = '' --库容月纪录

DELETE FROM [HY_YRV_F] where STCD = '' --库容年纪录

DELETE FROM [LH_V_DAY] where STCD = '' --库容统计表：日表

DELETE FROM [LH_V_MONTH] where STCD = '' --库容统计表：月表

DELETE FROM [LH_V_DAY_MinMaxAvg] where STCD = '' --库容统计表：最大最小值表 --水位

DELETE FROM [HY_DZ_C] where STCD = '' --水位日记录

DELETE FROM [HY_MTZ_E] where STCD = '' --水位月纪录

DELETE FROM [HY_YRZ_F] where STCD = '' --水位年纪录

DELETE FROM [HY_OBZ_G] where STCD = '' --水位记录表

DELETE FROM [LH_Z_DAY_JD] where STCD = '' --水位统计表：日表

DELETE FROM [LH_Z_MONTH_JD] where STCD = '' --水位统计表：月表

DELETE FROM [LH_Z_DAY_JD_MinMaxAvg] where STCD = '' --水位统计表：最大最小值表

DELETE FROM [LH_Z_DAY_XD] where STCD = '' --水位统计表：日表

DELETE FROM [LH_Z_MONTH_XD] where STCD = '' --水位统计表：月表

DELETE FROM [LH_Z_DAY_XD_MinMaxAvg] where STCD = '' --水位统计表：最大最小值表

DELETE FROM [Ep_SQ_JC] where STCD = '' --预警

DELETE FROM [LH_Z_R] where STCD = '' --实时表

--删除多个站点的相关数据【只删除数据，不删除基本信息】

--总表

DELETE FROM [In_Port_Log] where Hardware_Id in ('','')

DELETE FROM [In_Port_LogError] where Hardware_Idin ('','')

--降雨

DELETE FROM [HY_OBP_G] where STCD in ('','') --降雨记录表

DELETE FROM [ST_PPTN_R] where STCD in ('','') --降雨处理表

DELETE FROM [HY_DP_C] where STCD in ('','') --降雨日记录

DELETE FROM [HY_MTP_E] where STCD in ('','') --降雨月纪录

DELETE FROM [HY_YRP_F] where STCD in ('','') --降雨年纪录

DELETE FROM [Ep_YQ_JC] where STCD in ('','') --预警

DELETE FROM [LH_P_R] where STCD in ('','') --实时表

DELETE FROM [LH_P_DAY] where STCD in ('','') --降雨统计表：日表

DELETE FROM [LH_P_MONTH] where STCD in ('','') --降雨统计表：月表

--流量

DELETE FROM [ST_RIVER_R] where STCD in ('','') --河道处理表

DELETE FROM [HY_DQ_C] where STCD in ('','') --流量日记录

DELETE FROM [HY_MTQ_E] where STCD in ('','') --流量月纪录

DELETE FROM [HY_YRQ_F] where STCD in ('','') --流量年纪录

DELETE FROM [LH_Q_DAY] where STCD in ('','') --河道统计表：日表

DELETE FROM [LH_Q_MONTH] where STCD in ('','') --河道统计表：月表

DELETE FROM [LH_Q_DAY_MinMaxAvg] where STCD in ('','') --河道统计表：最大最小值表

--库容

DELETE FROM [ST_RSVR_R] where STCD in ('','') --库容处理表

DELETE FROM [HY_DV_C] where STCD in ('','') --库容日记录

DELETE FROM [HY_MTV_E] where STCD in ('','') --库容月纪录

DELETE FROM [HY_YRV_F] where STCD in ('','') --库容年纪录

DELETE FROM [LH_V_DAY] where STCD in ('','') --库容统计表：日表

DELETE FROM [LH_V_MONTH] where STCD in ('','') --库容统计表：月表

DELETE FROM [LH_V_DAY_MinMaxAvg] where STCD in ('','') --库容统计表：最大最小值表

--水位

DELETE FROM [HY_DZ_C] where STCD in ('','') --水位日记录

DELETE FROM [HY_MTZ_E] where STCD in ('','') --水位月纪录

DELETE FROM [HY_YRZ_F] where STCD in ('','') --水位年纪录

DELETE FROM [HY_OBZ_G] where STCD in ('','') --水位记录表

DELETE FROM [LH_Z_DAY_JD] where STCD in ('','') --水位统计表：日表

DELETE FROM [LH_Z_MONTH_JD] where STCD in ('','') --水位统计表：月表

DELETE FROM [LH_Z_DAY_JD_MinMaxAvg] where STCD in ('','') --水位统计表：最大最小值表

DELETE FROM [LH_Z_DAY_XD] where STCD in ('','') --水位统计表：日表

DELETE FROM [LH_Z_MONTH_XD] where STCD in ('','') --水位统计表：月表

DELETE FROM [LH_Z_DAY_XD_MinMaxAvg] where STCD in ('','') --水位统计表：最大最小值表

DELETE FROM [Ep_SQ_JC] where STCD in ('','') --预警

DELETE FROM [LH_Z_R] where STCD in ('','') --实时表

本文发布于:2024-09-23 15:24:44，感谢您对本站的认可！

本文链接：https://www.17tex.com/tex/2/389561.html

上一篇：工程教育认证背景下Linux系统实践课程教学改革的探索

下一篇：光学测量方法在手机跌落测试中的应用

标签：统计表删除水位数据纪录

留言与评论（共有 0 条评论）