Re: Compound Insert Statement

2006-03-30 Thread SGreen
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 [(

Re: Compound Insert Statement

2006-03-29 Thread sheeri kritzer
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