[thelist] probably simple SQL question
Chris Blessing
webguy at mail.rit.edu
Thu Jan 17 18:07:14 CST 2002
You got it. Use the semicolon to separate multiple sql statements.
Example:
sqlStr = "INSERT INTO myTable (field1, field2) VALUES ('John', 'Moe');" &_
"INSERT INTO my2ndTable (field1, field2) VALUES ('Well', 'Yeah')"
Chris Blessing
webguy at mail.rit.edu
http://www.330i.net
-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Marc Seyon
Sent: Thursday, January 17, 2002 7:04 PM
To: thelist at lists.evolt.org
Subject: [thelist] probably simple SQL question
Evolters with more knowledge of SQL than me (most everyone),
Am wondering about this. If I need to insert records into two (or more)
tables in a database is there a straightforward way to do this?
Along the lines of "Insert Into TableA xyz; Insert Into TableB zyx"
Hoping someone understands what I'm attempting to do and it's not too
impossible.
Thanks.
-marc
--
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !
More information about the thelist
mailing list