我只想同时插入多行。但我想忽略已经摆在桌子上的每一个人。我只是进行查询,但它有语法问题。有人能帮我解决这个问题吗?下面是我的sql查询:
INSERT INTO `targetmediaid` (`pageid`, `targetpageid`, `mediaid`)
SELECT "4578583556", "5633144318", "1544121716250721765_5633144318" UNION
SELECT "4578583556", "5633144318", "1544121605403655131_5633144318" UNION
SELECT "4578583556", "5633144318", "1544121513523117304_5633144318" UNION
SELECT "4578583556", "5633144318", "1544121293112402936_5633144318" UNION
SELECT "4578583556", "5633144318", "1544121119770209275_5633144318" UNION
SELECT "4578583556", "5633144318", "1544121021170710600_5633144318" UNION
SELECT "4578583556", "5633144318", "1544120871450810242_5633144318" UNION
SELECT "4578583556", "5633144318", "1542556083004139499_5633144318" as t
WHERE NOT EXISTS
( SELECT `pageid`, `targetpageid`, `mediaid`
FROM `targetmediaid`
WHERE `mediaid`
IN ("1544121716250721765_5633144318" ,
"1544121605403655131_5633144318" ,
"1544121513523117304_5633144318" ,
"1544121293112402936_5633144318" ,
"1544121119770209275_5633144318" ,
"1544121021170710600_5633144318" ,
"1544120871450810242_5633144318" ,
"1542556083004139499_5633144318"
) 发布于 2017-07-05 08:19:08
在pageid、targetpageid、mediaid列上创建唯一索引,并使用INSERT IGNORE语句。
INSERT IGNORE INTO targetmediaid (pageid, targetpageid, mediaid) VALUES ("4578583556", "5633144318", "1544121716250721765_5633144318"), ("4578583556", "5633144318", "1544121605403655131_5633144318"),("4578583556", "5633144318", "1544121513523117304_5633144318").....诸若此类。
https://stackoverflow.com/questions/44920213
复制相似问题