当前位置：首页 > news >正文

调整指标达成插入yjlx表的sql

news 2026/4/22 8:57:55

-- INSERT INTO "yjlx" ("yjlx_lxqj", "yjlx_lxrq", "yjlx_khbh", "yjlx_khmc", "yjlx_wlbh", "yjlx_wlmc", "yjlx_ggxh", "yjlx_jldw", "yjlx_sl", "yjlx_lxsl", "yjlx_lxdj", "yjlx_dj", "yjlx_je", "yjlx_gysbh", "yjlx_gysmc", "yjlx_ywy", "yjlx_ywymc", "yjlx_tzry", "yjlx_tzrymc", "yjlx_dqbh", "yjlx_gysdqbh", "yjlx_lrrq", "yjlx_lrry", "yjlx_pch", "yjlx_bz", "yjlx_ppkhmc", "yjlx_ppkhbh", "yjlx_spbh", "yjlx_xs", "yjlx_tzbz", "yjlx_khdj", "yjlx_djppbh", "yjlx_djppmc", "yjlx_tx", "yjlx_gyslb", "yjlx_sfzx", "yjlx_sfcx", "yjlx_dqmc", "yjlx_gszf", "yjlx_js", "yjlx_lsbz", "yjlx_xykh", "yjlx_wllb", "yjlx_xyjs", "yjlx_sffx", "yjlx_xybm", "yjlx_sybm", "yjlx_depart5", "yjlx_depart4", "yjlx_sf", "yjlx_ds", "yjlx_label", "yjlx_xybmmc","yjlx_sycategory", "yjlx_sylevel1", "yjlx_xylevel2", "yjlx_xyisflow", "yjlx_xyisotcflow", "yjlx_syisflow", "yjlx_syisotcflow", "yjlx_sydept1", "yjlx_type", "yjlx_lsxl_id", "yjlx_gzlx_id", "yjlx_remark", "yjlx_upd_by", "yjlx_upd_time", "yjlx_agent_client_id", "yjlx_agent_client_name", "yjlx_depart7", "yjlx_lx_wlbh") 
select 
"yjlx_lxqj", "yjlx_lxrq", "yjlx_khbh", "yjlx_khmc", "yjlx_wlbh", "yjlx_wlmc", "yjlx_ggxh", "yjlx_jldw", "yjlx_sl", "yjlx_lxsl", "yjlx_lxdj", "yjlx_dj", "yjlx_je", "yjlx_gysbh", "yjlx_gysmc", "yjlx_ywy", "yjlx_ywymc", "yjlx_tzry", "yjlx_tzrymc", "yjlx_dqbh", "yjlx_gysdqbh", "yjlx_lrrq", "yjlx_lrry", "yjlx_pch", "yjlx_bz", "yjlx_ppkhmc", "yjlx_ppkhbh", "yjlx_spbh", "yjlx_xs", "yjlx_tzbz", "yjlx_khdj", "yjlx_djppbh", "yjlx_djppmc", "yjlx_tx", "yjlx_gyslb", "yjlx_sfzx", "yjlx_sfcx", "yjlx_dqmc", "yjlx_gszf", "yjlx_js", "yjlx_lsbz", "yjlx_xykh", "yjlx_wllb", "yjlx_xyjs", "yjlx_sffx", "yjlx_xybm", "yjlx_sybm", "yjlx_depart5", "yjlx_depart4", "yjlx_sf", "yjlx_ds", "yjlx_label", "yjlx_xybmmc","yjlx_sycategory", "yjlx_sylevel1", "yjlx_xylevel2", "yjlx_xyisflow", "yjlx_xyisotcflow", "yjlx_syisflow", "yjlx_syisotcflow", "yjlx_sydept1", "yjlx_type", "yjlx_lsxl_id", "yjlx_gzlx_id", "yjlx_remark", "yjlx_upd_by", "yjlx_upd_time", "yjlx_agent_client_id", "yjlx_agent_client_name", "yjlx_depart7", "yjlx_lx_wlbh"
from yjlx2026 where yjlx_lxqj='202603'
-- delete from yjlx;