在SQL中删除或更新重复值

Question

I have put a unique index on my database table for steamid. I am unsure how I can insert a record with duplicate values for this key (dropping the old record) without getting an error. Could someone edit my code to make it suitable, Thanks.

$sql = "INSERT INTO steam_data (reg_date, reg_year, steamname, steamid) VALUES ('$dateoutput', '$dateoutputyear', '$personaname', '$steamid')";

The error is :

Error: INSERT INTO steam_data (reg_date, reg_year, steamname, steamid) VALUES ('March 20, 07:09pm', '2017', 'Aweosmedude', '76561113498123831721') Duplicate entry '76561113498123831721' for key 'steamid'

Answer 1

It means you already have a record in your steam_data table with streamid=76561113498123831721; and you have a constraint in your schema that ensures that you don't have more than one streamid. So you can either do INSERT IGNORE INTO stream_data... or do INSERT INTO stream_data...ON DUPLICATE KEY...

e.g.

INSERT INTO steam_data (reg_date, reg_year, steamname, steamid) VALUES ('$dateoutput', '$dateoutputyear', '$personaname', '$steamid') ON DUPLICATE KEY UPDATE steamname=VALUES(steamname);

(@ReneS answer has example of INSERT IGNORE INTO...)