On Fri, Jun 6, 2008 at 9:25 PM, TUT - LightSpeed <[EMAIL PROTECTED]> wrote:
>
> Actually they are 2 connection to 2 different databases on 2 different
> hosts.
> I wanted rquery results from db1 to be in a temporary table to be used in
> db2.
> I can go around it with some php code to create the t
On Fri, Jun 6, 2008 at 2:28 PM, TUT - LightSpeed <[EMAIL PROTECTED]> wrote:
> I have this problem
>
> I connect to 2 database servers in the same script
>
> If I create a temp table on one, won't be able on the other
>
> $db1 = db_connect1();
> $db2 = db_connect2();
>
> I get error that temp_table
On Mon, May 12, 2008 at 11:36 AM, Jake Conk <[EMAIL PROTECTED]> wrote:
>
> SELECT * FROM whiles WHERE owner_id= first THEN SELECT * FROM
> files ORDER by file_id
>
Would this work?
SELECT *
FROM whiles
WHERE owner_id =
ORDER BY owner_id = DESC, file_id
On 11/13/07, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
>
> hi there,
>
> i have a text file that i prepare:
>
> insert into `sa2007` (`id`,`amount`,`state`) values
> ('','1.00','oh'),
> ('','2.00','il'),
> ('','4.00','ks')
>
> how do i import this file to sa2007 table from the command line? i tried
>
