我有一张桌子和一张桌子的后座。备份后,在主表中插入一些数据。现在我想从主表中删除数据。如何实现这一目标?假设表是'BookMap‘,列AuthorID,BookName,BookID。获取“BookMap”表的备份并插入新数据。现在要删除这些数据。
注意:这里没有主键。
发布于 2016-08-12 13:00:52
如果您希望BookMap看起来像backup_BookMap,那么您可以考虑:
truncate table bookmap;
insert into bookmap( . . .)
select . . .
from backup_bookmap;发布于 2016-08-12 13:01:06
如果我对您的理解是正确的,您希望从非备份表中删除已插入到备份表中的数据:
DELETE nonbackup
FROM BookMap as nonbackup
WHERE nonbackup.BookID IN
(
SELECT BookID
FROM BookMapBackup as backup
)发布于 2016-08-12 13:02:28
就像这样,
DELETE B FROM bookmark B INNER JOIN
(
SELECT *FROM (
select *From bookmark
except
select *From bookmarkbackup)T
)T1 ON T1.AuthorID=B.AuthorID
AND T1.BookName=B.BookName
AND T1.BookID=B.BookIDhttps://stackoverflow.com/questions/38918547
复制相似问题