使ç¨replace intoï¼ç¨æ³åinsert
ç´æ¥ææ°æ°æ®çæ¹æ³åæ°æ®åºä¸æå
¥æ°æ®ï¼å
¶ä¸id为主é®ï¼å¦æç¨insertä¼æ¥å²çªé误ï¼èç¨replaceä¼ç¸å½äºæ§è¡äºupdateè¯å¥
å¯ä»¥ç¨ INSERT INTO table(column1,column2,column3 ...columnN) SELECT value1,value2,value3 ...valueN FROM dual WHERE NOT EXISTS( SELECT * FROM table WHERE value = ? );
温馨提示:答案为网友推荐,仅供参考