Re: Temp table on multiple connections

2008-06-08 Thread Omni Adams
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 table in

Re: Temp table on multiple connections

2008-06-06 Thread Omni Adams
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 doesn't

Re: Selecting my data first

2008-05-12 Thread Omni Adams
On Mon, May 12, 2008 at 11:36 AM, Jake Conk [EMAIL PROTECTED] wrote: SELECT * FROM whiles WHERE owner_id=my_id first THEN SELECT * FROM files ORDER by file_id Would this work? SELECT * FROM whiles WHERE owner_id = my_id ORDER BY owner_id = my_id DESC, file_id

Re: Help needed

2008-05-12 Thread omni
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 does

Re: load data

2007-11-13 Thread Omni Adams
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 via

Re: REVOKE ERROR

2007-09-17 Thread omni
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 what is the