RE: [PHP-DB] table 1 to table 2

I was thinking that MySQL doesn't support subselects ?! Or is there a new MySQL-Version which does support them ? Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - _______________________________________________________________ Suchtreffer AG Bleicherstraße 20 D-78467 Konstanz Germany fon: +49-(0)7531-89207-17 fax: +49-(0)7531-89207-13 e-mail: mailto:mru@suchtreffer.de internet: http://www.suchtreffer.de _______________________________________________________________ > -----Original Message----- > From: Cal Evans [mailto:cal@calevans.com] > Sent: Monday, March 26, 2001 9:53 PM > To: tobe@johnsons.net; PHP-DB > Subject: RE: [PHP-DB] table 1 to table 2 > > > insert into table2 Select * from table1 where myConditionIsMet; > > > Cal > http://www.calevans.com > > > -----Original Message----- > From: Tobe Johnson [mailto:tobe@johnsons.net] > Sent: Monday, March 26, 2001 1:41 PM > To: PHP-DB > Subject: [PHP-DB] table 1 to table 2 > > > Using PHP, I need to run a query against one MySQL database > table (table1) > and transfer the results into another identical MySQL database table > (table2). Am I simply overlooking something simple on how to > do this? Can > someone give me input or direction on the best way to do this? > > Thanks in advance > > Tobe > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net >