插入或忽略更新前一行？

Question

I have following table

I am trying if I have new record with same email id. I want to update previous records with that emailId in single query.

I don't want to update record with i have duplicate record. I am using insert ignore for that.

Any help?

Answer 1

make email-id as a primary key and use the following Query

INSERT INTO table_name
VALUES
    ('id', 'email', 'val1', 'val2') ON DUPLICATE KEY UPDATE 'something

'