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> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php