All pastes #633375 Raw Edit

Anonymous

public text v1 · immutable
#633375 ·published 2007-07-25 17:12 UTC
rendered paste body
mysql> INSERT INTO home_user (home_user_id,firstname,lastname,emailathome,status,regdate,enddate,renewdate,payments,product,               
    -> futurepayid,transid,address,postcode,job,recommended,
    -> failures,mailinglist)
    -> SELECT home_user_id,firstname,lastname,emailathome,status,regdate,enddate,renewdate,payments,product,                               
    -> futurepayid,transid,address,postcode,job,recommended,
    -> failures,mailinglist
    -> FROM samrevamp.home_user;
ERROR 1582 (23000): Duplicate entry '2' for key 'PRIMARY'