MYSQL 先判断后插入数据防止超出
insert into enterprisecontrol
(enterprise_id,control_id,time,status)
SELECT #{enterprise_id},#{control_id},#{time},#{status}
from DUAL
where not exists(select enterprisecontrol.enterpriseControl_id from enterprisecontrol where enterprise_id = #{enterprise_id} and control_id = #{control_id} );
可能不管用,不过写了以后明显可以控制