Sheeri is correct. Rich's statement should have worked. What Rich is
looking for is the syntax for doing what the manual calls "extended
inserts".
quoting TFM (http://dev.mysql.com/doc/refman/5.0/en/insert.html)
INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name [(
That is, in fact, the exact correct syntax. What error are you
getting when you try to run that on the commandline? What version of
MySQL are you using?
-Sheeri
On 3/29/06, Rich <[EMAIL PROTECTED]> wrote:
> Hi folks. I come to the list with another compound question.
>
> My middleware allows m
Hi folks. I come to the list with another compound question.
My middleware allows me to build any syntax for the actual sql
statement, so I'm trying to minimize the work done to insert several
records at one try. I currently have multiple insert statements, but
can't find any reference to mu
