MySQL multirow inserts
No Comments »
I was surprised to see how few people know that in MySQL you can do :
INSERT INTO tbl_01(id, name) VALUES (1, ‘One’)
INSERT INTO tbl_01(id, name) VALUES(2, ‘Two’)
But also
INSERT INT tbl_01(id, name) VALUES
(1, ‘One’), (2, ‘Two’)
In practice it is very useful.
