o
i don't think you can
you'd just have to post two separate insert statments
you can run them both at the same time if you like though
INSERT INTO table (booknum, isbn, title) values ('001', '1-56592-434-7',
'MySQL & mSQL');
INSERT INTO table (booknum, isbn, title) values ('002', '1-56592-257-3',
'Mastering Regular Expressions');
the only other way to do it would be to
import the data from another database like this:
INSERT INTO table [ (coloumn...) ] SELECT ...
OR
use a LOAD DATA and import a text file.
hope that helps
----- Original Message -----
From: "Bob Rea" <[EMAIL PROTECTED]>
To: "daniel" <[EMAIL PROTECTED]>
Sent: Monday, February 25, 2002 4:40 PM
Subject: Re: Beginner needs help
> On Monday 25 February 2002 03:51 pm, you wrote:
> > my $0.02:
> >
> > insert into TABLE (booknum, isbn, title) values ('001',
> > '1-56592-434-7', 'MySQL & mSQL');
> >
> > you want to keep all your field names on the left of
> > values and all your data on the right. only two sets of
> > brackets "()".
>
> But I'm trying to insert *two* sets of values in the same
> insert statement. What am I doing wrong?
>
> --
> Bob Rea
>
> **************************************************
> "On the side of the box, under 'System
> Requirements', it said 'Requires Windows
> 95 or better'. So I installed Linux."
> **************************************************
>
> [EMAIL PROTECTED] http://home.earthlink.net/~sfpetard/
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
