> YOu'll have to list the fields explicitly, except for the primary > key. For example, if your table has columns: > > id (PK) > data_1 > data_2 > data_3 > > you should be able to do > > insert into table_name (data_1, data_2, data_3) select > data_1,data_2,data_3 from table_name where id=1 > > The insert failed because you were - as the error message said - > trying to insert a record with an existing primary key, which is > unique. > > Check mysql manual for more info on syntax of insert command.
I figured as much, its just two sets of fields I will have to manage, which is why I was hoping there was a sneaky SQL way to deal with it. Thanks. -- ------------------------------------------------------------- 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]