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
Bleicherstraße 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]