To Duplicate a Row?

[Jan Steinman]

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>