"David" <[EMAIL PROTECTED]> 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/ --------------------------------------------------------------------- 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
