删除数据的sql语句.doc

删除数据的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