INSERT INTO table1(AA
, BB
, CC
) SELECT NULL, ‘2’, ‘1’, ‘3’ FROM TMP WHERE NOT EXISTS(SELECT AA FROM table1 WHERE AA = ‘2’); // TMP为中间表
整理自网络
按条件insert
最新推荐文章于 2022-04-07 15:51:48 发布
INSERT INTO table1(AA
, BB
, CC
) SELECT NULL, ‘2’, ‘1’, ‘3’ FROM TMP WHERE NOT EXISTS(SELECT AA FROM table1 WHERE AA = ‘2’); // TMP为中间表
整理自网络