MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Duplicate records plus update at the same time
Posted by: Rick James
Date: November 06, 2014 09:24AM

What? Are you trying to shift the IDs? That is not kosher.

BEGIN;
UPDATE tbl SET id = id + 1; -- UGH.
INSERT .. SELECT ..;
COMMIT;

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Duplicate records plus update at the same time
Andre Basel
November 04, 2014 03:32PM
Re: Duplicate records plus update at the same time
Rick James
November 06, 2014 09:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.