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

[Michael Rudel]

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
Bleicherstrae 20
D-78467 Konstanz
Germany
fon: +49-(0)7531-89207-17
fax: +49-(0)7531-89207-13
e-mail: mailto:[EMAIL PROTECTED]
internet: http://www.suchtreffer.de
___



 -Original Message-
 From: Cal Evans [mailto:[EMAIL PROTECTED]]
 Sent: Monday, March 26, 2001 9:53 PM
 To: [EMAIL PROTECTED]; 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:[EMAIL PROTECTED]]
 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: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail:
 [EMAIL PROTECTED]



 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail:
 [EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

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

[Cal Evans]

insert into table2 Select * from table1 where myConditionIsMet;


Cal
http://www.calevans.com


-Original Message-
From: Tobe Johnson [mailto:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]