>Yes. You can use INSERT INTO <table> select from ...... >> If this matters, I will be doing this in 2 different applications. 1 >> database is MySQL, and the other is MS Access.
Not if the two tables are on different database servers. But maybe I'm reading that wrong and the application is just being developed to run on two different instances. -----Original Message----- From: KH Chiu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 6:52 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Is this query possible... Yes. You can use INSERT INTO <table> select from ...... Regards, > All, > > Is this query possible to do: > > I am going to select an id from a table > > SELECT order_id FROM orders WHERE order_start = 1324 > > I will then use the order_id from this query and insert it as well as > some others values I have into another table. > > So in summary, I want to perform a SELECT and INSERT in the same > database query. > > Can I do it? > > If this matters, I will be doing this in 2 different applications. 1 > database is MySQL, and the other is MS Access. > > -jonathan --------------------------------------------------------------------- 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
