| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Steve Werby | Date: | July 14 2001 2:05pm |
| Subject: | Re: How do you insert into two tables at once | ||
| View as plain text | |||
"David" <fates-w@stripped> wrote: > I have two tables under the one database. What is the best way to > INSERT data into both tables at once. Can I use one INSERT statement or > do I have to use two? Two inserts are required. You can insert multiple rows into a table via a single insert, but not into multiple tables. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/
| Thread | ||
|---|---|---|
| • How do you insert into two tables at once | David | 14 Jul |
| • Re: How do you insert into two tables at once | Steve Werby | 14 Jul |
| • Re: How do you insert into two tables at once | Tonu Samuel | 15 Jul |