《删除数据的sql语句》由会员分享,可在线阅读,更多相关《删除数据的sql语句(5页珍藏版)》请在金锄头文库上搜索。
1、删除数据的删除数据的 sqlsql 语句语句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 w
2、here 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 = -流量
3、日记录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 ST
4、CD = -库容日记录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 w
5、here 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 = -水位统计表:日表DE
6、LETE 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
7、_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 wh
8、ere 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 (,) -流量年
9、纪录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 (,) -库容月纪录
10、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 (,) -水位月纪录DEL
11、ETE 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 (,) -实时表