Re: trouble with group by and similar tables

Hi Eben, all ! Eben schrieb: I have the following tables: table1 --- id1 some_field table2 --- id id1 score table3 --- id id1 score I then have the following query: SELECT table1.id,SUM(table2.score) as table2_score FROM table1, table2 WHERE table1.some_field = 'value' AND

Re: mysqld-nt Windows service: delay btwn svc running and accepting conx

Hi Les, all ! Les Schaffer schrieb: [[...]] perhaps i wasn't clear earlier. we checked the logs, and we see that Innodb is started and accepting connections sometimes 1-6 seconds AFTER we see the Windows ServiceManager report that the MySQL service is in state SERVICE_RUNNING. we had

converting myisam tables to innodb.

Hi All, I am converting some of the myisam tables to innodb. What are the things i need to take care before doing this and also after doing this. regards anandkl

Re: trouble with group by and similar tables

Hi Joerg, Joerg Bruehe wrote: Hi Eben, all ! Eben schrieb: I have the following tables: table1 --- id1 some_field table2 --- id id1 score table3 --- id id1 score I then have the following query: SELECT table1.id,SUM(table2.score) as table2_score FROM table1, table2 WHERE

Re: mysqld-nt Windows service: delay btwn svc running and accepting conx

Joerg Bruehe wrote: I assume Windows reports the status as running when the process(es) got started, but that doesn't necessary imply they have passed their own initialization / startup phase. I doubt there is any external event (say, a file creation or some such) that Windows would

Temp table on multiple connections

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(); $query = CREATE TEMPORARY TABLE temp_table SELECT ..; $result = mysql_query($query,$db1) or

Re: Temp table on multiple connections

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: Temp table on multiple connections

Hi Omni, Thanks for the reply. I know it couldn't be possible. I just wanted to hear opinions. 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