mysql使用begin时报错，小白求助

Question

想实现的功能是插入前需要满足表A和表B中存在某字段两个条件，两个条件满足时才执行插入

IF EXISTS (select * from criminal_info where criminal_info.criminal_id='123456') AND exists (select * from criminal_families_info where criminal_families_info.user_id='123')then
begin
insert into criminal_families_relationship (`user_id`,`user_bind_id`,`user_name`) values( '123','456','tom');
end

执行语句时报错，根据网上的说法使用delimiter更换间隔符也无法解决，小白求大佬解惑

Answer 1

建议采用触发器进行判断是否可以正常插入