mysql conditional insert - if not exists insert - multi value insert

Question

From my previous question this was the solution I am accepting:

INSERT IGNORE INTO table_name
SET name = 'phill',
    value = 'person',
    id = 12345;

But I also wanted to know if I could be multiple values like this

INSERT IGNORE INTO table_name
SET (name = 'phill', value = 'person', id = 12345),
    (name = 'bob', value = 'person', id = 12346);

a1ex07 · Accepted Answer · 2010-02-08 19:33:56Z

4

INSERT IGNORE INTO table_name(name,value,id) VALUES 
('phill','person',12345),('bob','person',12346)

answered Feb 8, 2010 at 19:33

a1ex07

37.4k12 gold badges94 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

if id 12345 already exists, does the entire insert fail or only that single row? In other words, if phill exists, will bob still be inserted?

@alex9311: Only rows that cause error are discarded, not the whole statement .