In the last episode (Mar 31), Chris W. Parker said:
> I searched the archives, looked through the manual, and searched
> google for info on how to actually perform a multi-row INSERT but
> didn't find an answer.
> Would someone please show me the syntax for this please?
> I could just do a loop and INSERT the data that way but according to the
> manual, a multi-row INSERT is faster.
The syntax is described in the manual, but not with an explicit
example. One of the user comments gives an exaple.
INSERT INTO mytable (f1,f2,f3) VALUES (1,2,3),(4,5,6),(7,8,9);
will insert three rows. Just tack as many ,(...) clauses on the end as