|||
在工作中使用的一些数据库基本操作,不是经常使用,容易忘记,放到这里做个笔记
-- 从结果集中拷贝---------------------------------------
--------------------------------------------------------
-- DELETE FROM ndg_czxx WHERE 1=1;
-- DELETE FROM t_cjmxb WHERE 1=1;
-- DELETE FROM t_czxx WHERE 1=1;
-- DELETE FROM t_dnxx WHERE 1=1;
-- DELETE FROM t_fqrjxx WHERE 1=1;
-- DELETE FROM t_gilts_begin_month WHERE 1=1;
-- DELETE FROM t_gilts_begin_month12 WHERE 1=1;
-- DELETE FROM t_gilts_end_month WHERE 1=1;
-- DELETE FROM t_gzgmxx WHERE 1=1;
-- DELETE FROM t_gzrqxx WHERE 1=1;
-- DELETE FROM t_gzswfaxx WHERE 1=1;
-- DELETE FROM t_gzswxx WHERE 1=1;
-- DELETE FROM t_gztj WHERE 1=1;
-- DELETE FROM t_gzxsxx WHERE 1=1;
-- DELETE FROM t_gzzcxx WHERE 1=1;
-- DELETE FROM t_gzzrxx WHERE 1=1;
-- DELETE FROM t_jbxx WHERE 1=1;
-- DELETE FROM t_lcxx WHERE 1=1;
-- DELETE FROM t_lcxx_copy1 WHERE 1=1;
-- DELETE FROM t_mzswxx WHERE 1=1;
-- DELETE FROM t_mzxsxx WHERE 1=1;
-- DELETE FROM t_mzztb WHERE 1=1;
-- DELETE FROM t_pzmx WHERE 1=1;
-- DELETE FROM t_pzxx WHERE 1=1;
-- DELETE FROM t_pzxx2 WHERE 1=1;
-- DELETE FROM t_zzswxx WHERE 1=1;
-- DELETE FROM temp_addpzid2czxx WHERE 1=1;
-- DELETE FROM temp_gilts_use WHERE 1=1;
-- DELETE FROM temp_mzscsy WHERE 1=1;
Archiver|手机版|科学网 ( 京ICP备07017567号-12 )
GMT+8, 2024-12-14 16:00
Powered by ScienceNet.cn
Copyright © 2007- 中国科学报社