潘钊 / bsth_control · Files

select * from bsth_c_s_sp_rule_rst;

select * from bsth_c_s_sp_rule_rst
where qyrq is null;

update bsth_c_s_sp_rule_rst a
set a.qyrq = (select qyrq from bsth_c_s_sr1_flat where id = a.rule_id)
where a.qyrq is null;

select * from bsth_c_s_sp_rule_rst
where origingidindex is null;

update bsth_c_s_sp_rule_rst a
set a.origingidindex = (select lp_start from bsth_c_s_sr1_flat where id = a.rule_id)
where a.origingidindex is null;

970
789
604
985
北蔡2路
1048
1118
上南二分通勤


-Xms128M -Xmx1024M -XX:PermSize=64M -XX:MaxPermSize=128M

1118
572康桥
83