tags:

views:

204

answers:

1

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);
+2  A: 
INSERT IGNORE INTO table_name(name,value,id) VALUES 
('phill','person',12345),('bob','person',12346)
a1ex07
duh, LOL thnx should have tried this way as well
Phill Pafford