MySQL SELECT Statement with Date help request

Hi List, I am wondering if someone can help me with a query to check what databases are on the MySQL server and then check which of those databases are either partially or completely within the date range i require. The scenario is as follows: db1 : 2007-01-01 to 2007-02-01 db2 : 2007-02-01 to 2

Re: selecting data from 2 local DBs with same table structure

tbl1 GROUP BY name; ? PB - Cx Cx wrote: Hello List! Does anybody know how to select and build a result set from two or more databases with the same table structures that are on the same server. I need the query to select the data from table1 on db1 and then select the data from table1 on db2 a

selecting data from 2 local DBs with same table structure

Hello List! Does anybody know how to select and build a result set from two or more databases with the same table structures that are on the same server. I need the query to select the data from table1 on db1 and then select the data from table1 on db2 and return a result of where if a field dat

Database Performance Tweaking

Hi All, Hope this is the right list to post to, excuse if it is not ;-) Server scenario: Dedicated server running MySQL 4 and secondary process inserting data into MySQL How does one calculate what the values should be for the following areas in the my.cfg file to give optimal performance: