sql优化,建表用触发器更新表
项目中用到一张表,然后sql是一条需要关联两张表的查询的,所以比较慢
SELECT c.name juwei,count(1) as value FROM j_sq_rjbxx a,j_dict_xzqh_china b,j_dict_xzqh c WHERE concat( substr( a.HJDXZQHDM, 1, 2 ),'0000' ) = b.dm AND a.syrklbdm ...
原创
2019-06-26 20:36:30 ·
10050 阅读 ·
0 评论