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'