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: <>
: Bytesmiths -- artists' services: <>
: Join the forums at <>

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