INSERT INTO sync_test2 (id,product_id,test_json)
select 20,'tttq1','[20]' from DUAL
where NOT EXISTS (SELECT id,product_id,test_json from sync_test2 where product_id = 'tttq1')
mysql解决插入根据某条件判断是否插入
最新推荐文章于 2022-12-08 10:54:09 发布