mySQL requires one insert command per
table. Stop being lazy, *grin*
P
On Wed, 18 Apr 2001, Fates wrote:
> How do I insert data into multiple tables without having to use multiple
>
> insert statements? Can I just do Insert into table1 (data) table2
> (data)
> table3 (data) or do I have to use seperate INSERT statements for each
> table? I would like to add all at once from web page form
>
>
> $query = "INSERT INTO $table VALUES ('$menu_id', '$server',
> '$menunumber', '$menuname')";
>
> --
> This email was sent using w3mail.
>
>
> ---------------------------------------------------------------------
> 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
>
>
--
-----------------------------------------------
Peter Skipworth
Perl Developer/Unix Systems Administrator
[EMAIL PROTECTED]
+44 795 055 0029
-----------------------------------------------
4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61
20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a
---------------------------------------------------------------------
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
