Canman2005 Posted October 18, 2008 Share Posted October 18, 2008 Hi all Is there an easy way to duplicate a row in the same table, basically I have a table with tons of data and with a click of a button, I want to run a QUERY to duplicate all the contents of that rows ID number. Any help would be great Thanks Quote Link to comment Share on other sites More sharing options...
DarkWater Posted October 18, 2008 Share Posted October 18, 2008 What do you mean? Quote Link to comment Share on other sites More sharing options...
Canman2005 Posted October 18, 2008 Author Share Posted October 18, 2008 Well I mean is there any way to say DUPLICATE ROW with ID NUMBER 2 and then it would duplicate everything in ROW 2 and copy it into the same table If that makes better sense Quote Link to comment Share on other sites More sharing options...
AndyB Posted October 18, 2008 Share Posted October 18, 2008 It's hard to imagine a good reason for duplicating a row into the same table. Perhaps if you explain your objective, you'll get a rational solution. Quote Link to comment Share on other sites More sharing options...
Canman2005 Posted October 18, 2008 Author Share Posted October 18, 2008 It's ok, found a solution. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.