List:General Discussion« Previous MessageNext Message »
From:Jan Steinman Date:October 3 2002 7:42pm
Subject:To Duplicate a Row?
View as plain text  
Is there a simple way to duplicate one or more rows in a table?

I tried:

  INSERT INTO table SELECT * FROM table WHERE criteria

but apparently INSERT...SELECT cannot function on the same table.

----- filter fodder, ignore -----
sql query (I swear, I'm gonna put that in my .signature soon... :-)
-- 
: Jan Steinman -- nature photography: <http://www.Bytesmiths.com>
: Bytesmiths -- artists' services: <http://www.Bytesmiths.com/Services>
: Join the forums at <http://www.Bytesmiths.com/wiki>

Thread
To Duplicate a Row?Jan Steinman3 Oct
  • Re: To Duplicate a Row?Roger Baklund4 Oct