Hi.
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'),....
Kittiphum Worachat,M.T.
www.hatyailab.com
>
> 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')
>
> insert into mytable (id,name,job_number,job_date) values
> ('2','Mark','AA2','2002-04-16')
>
> insert into mytable (id,name,job_number,job_date) values
> ('3','Mark','AA3','2002-04-17')
>
> - all at once if the data is the result of a form page.
>
> cheers
>
> Mark
>
>
> --------------------------------------
> Mark Dale
>
> phone/fax: 02 6247.6731
> mobile: 0403.831748
> email: [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
---------------------------------------------------------------------
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
