Multiple INSERT’s in MySQL
Did you know you can actually do multiple record inserts in one mysql query? Well, since version 3.22.5 anyway… Just group each value set in parenthesis and seperate via commas - and bobs your uncle!
< ?php
$query = "INSERT INTO results (firstname, lastname, score)
VALUES
('joe', 'bloggs', 77),
('mary', 'jane', 80),
('matthew', 'heinze', 60)";
mysql_query($query);
?>
