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 [(col_name,...)]
    VALUES ({expr | DEFAULT},...),(...),...
    [ ON DUPLICATE KEY UPDATE col_name=expr, ... ]
<<<<

That means that his 4 statements could be rewritten as :

INSERT INTO mytable (myfield) VALUES ('alpha'), ('bravo'), ('charlie'), 
('delta');

Which is what he posted as his "desired" syntax.  What puzzles me is if he 
got it right the first time, why did he post the question?

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

"sheeri kritzer" <[EMAIL PROTECTED]> wrote on 03/30/2006 12:41:01 AM:

> 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 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 multiple records added using one insert
> > statement.  I now have:
> >
> > -SQL = "INSERT INTO mytable (myfield) VALUES ('alpha');INSERT INTO
> > mytable (myfield) VALUES ('bravo');INSERT INTO mytable (myfield) 
VALUES
> > ('charlie');INSERT INTO mytable (myfield) VALUES ('delta');"
> >
> > What I would like to find is this:
> >
> > -SQL = "INSERT INTO mytable (myfield) VALUES ('alpha'), ('bravo'),
> > ('charlie'), ('delta')";
> >
> > I am either looking in the wrong place in Dubois (Third) or it can't 
be
> > done.
> >
> > Any recommendations?
> >
> > Appreciate it.
> >
> > Cheers
> >
 

Reply via email to