Inserting data to multiple table at once
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
Re: Inserting data to multiple table at once
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
RE: Inserting data to multiple table at once
Yeah, it does require one insert command per table, thats why some people
like transaction capability in tables. If we all could insert data into
multiple tables with one insert command then we wouldn't need transaction
support would we? H, that would be nice though! :o)
Patrick
-Original Message-
From: Peter Skipworth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 11:47 AM
To: Fates
Cc: [EMAIL PROTECTED]
Subject: Re: Inserting data to multiple table at once
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
-
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
