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 8:31 AM, Velen <[EMAIL PROTECTED]> wrote:
> Hi Arthur,
>
> Could you please tell this guy that it was not a virus and you tested it
> without any problem?
>
One guy that is brave/crazy/stupid enough to run a binary on his machine
that didn't have anything bad happen to him
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
>
On 9/16/07, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi Baron,
>
> Still i am able to connect through the following command.
> mysql -h 192.168.1.10 -u test -p test
>
> although drop user can be used to drop the user but revoke command should
> work properly. I don't understand wha