比如,给学生A
添加记录,但是需要判断学生A是否存在
insert
into
mt_blacklist (merchant_id,
numbering,
remark,
create_time,
blacklist_type,
id_switch)
select
1001,
'2022032914092244',
'这是备注',
now(),
'1',
'1'
from
mt_merchant
where
merchant_id = 1
merchant_id = 1 不成立的结果
merchant_id = 1 不成立的结果