Insert Or Ignore with update previous row?

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?

Possible duplicate of [How to INSERT a record or UPDATE if it already exists?](http://stackoverflow.com/questions/1952922/how-to-insert-a-record-or-update-if-it-already-exists) — Marcin Orlowski, Feb 04 '17 at 10:13

score -1 · Answer 1 · edited Feb 04 '17 at 10:04

-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

'

edited Feb 04 '17 at 10:04

Faisal

answered Feb 02 '17 at 09:01

Pavankant

1 Answers1