Hi.
Just use
INSERT INTO mytable (id,name,job_number,job_date)
VALUES ('1','Mark','AA1','2002-04-15'), ('2','Mark','AA2','2002-04-16'),
('3','Mark','AA3','2002-04-17') [and so on...]
Also see http://www.mysql.com/doc/I/N/INSERT.html
Bye,
Benjamin.
On Sun, Apr 14, 2002 at 11:10:22PM -0400, [EMAIL PROTECTED] wrote:
>
> Does anyone know if it's possible to insert mutilple records into 1 table
> in one query?
>
> Something like -
>
> insert into mytable (id,name,job_number,job_date) values
> ('1','Mark','AA1','2002-04-15')
[...]
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
