John: Try:
Insert into TABLE Select * from TABLE where TABLEID = ?; Update TABLE set column = 'desired value' where TABLEID = newPK; It's a bit manual, but defn the quick and dirty for a single row now and again. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -----Original Message----- From: John Mistler [mailto:[EMAIL PROTECTED] Sent: Thursday, June 10, 2004 1:40 PM To: [EMAIL PROTECTED] Subject: COPY row? Is there a COPY row or DUPLICATE row command? I would like to duplicate a row with in a table with 38 columns (auto-incrementing the Primary Key on the copied row, of course) and then alter the entry in ONE of its columns. Can this be done without doing a SELECT, then INSERT, then UPDATE? Thanks, John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]