Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE `assignments` SET `PlayerId`='45' WHERE `CampaignId`='3' AND `PlayerId`='2101'
- AND NOT EXISTS ( SELECT NULL FROM `assignments` WHERE `CampaignId`='3' AND `PlayerId`='2101' )
- #1093 - Table 'assignments' is specified twice, both as a target for 'UPDATE' and as a separate source for data
- ON DUPLICATE KEY DELETE
Add Comment
Please, Sign In to add comment