MySQL Forums
Forum List  »  Newbie

How to perform incrementation of ID
Posted by: Simon Stuart
Date: July 17, 2011 08:47PM

hello guys, I need help.

I have downloaded the back up of our database, then edit it using notepad. yes, using a notepad. Now my concern is, I want to duplicate each records on my database, without affecting the other entry. so I want to change the ID fast, without doing them one by one (it's tedious and made my eye to sour).

Can you provide me a SQL Statement to make it happen? Any help is much appreciated

Online Concierge Directory
www.philippineparadisepages.com



Edited 1 time(s). Last edit at 07/17/2011 08:48PM by Simon Stuart.

Options: ReplyQuote


Subject
Written By
Posted
How to perform incrementation of ID
July 17, 2011 08:47PM


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.