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
最新推荐文章于 2024-07-14 03:55:04 发布
INSERT INTO table1(AA
, BB
, CC
) SELECT NULL, ‘2’, ‘1’, ‘3’ FROM TMP WHERE NOT EXISTS(SELECT AA FROM table1 WHERE AA = ‘2’); // TMP为中间表
整理自网络