Can someone tell me how to take one record and duplicate it exactly, with the exception of the pk, which I want to increment as usual.
I think I need insert select, however, I don't want to name all the fields, as it would break over time, if I add or subtract fields. I seem to recall using a wildcard tossed me up an error about a duplicate key. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]