Where to index - over 15m records and growing

Hi All, I have a huge issue with a query - it copies the entire table to a tmp table when executing the query - and it's a big ass table Any help and/or pointers please? The query: SELECT COUNT(FlightRoutes.FlightID) AS Count, FlightRoutes.Dep AS Dep, FlightRoutes.Des AS Des FROM FlightRoute

Re: Changing date result automatically

I was referring to the function: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format --- Weydson Lima weys...@gmail.com On Thu, May 6, 2010 at 1:58 PM, Martin Gainty wrote: > http://lists.mysql.com/commits/60834 > > date_format system variable is currentl

New MySQL InStall

Can anyone give me some info here I want to install MySQL on a Vista Home Edition Laptop Can anyone tell me what I should download from the site? I want to run a java app. What version is stable and does it matter the operating system? Thank-YouMike

Changing date result automatically

Hi, Is there any way to format all dates generated by a MySQL query as US format? What I want to do is having a generic way to use the DATE_FORMAT function on all my date fields, instead of having to enter them manually. Thank you --- Weydson Lima weys...@gmail.com http://bluetoothmono.weydson.c

Re: limiting acess by Triggers

*Column Privileges* Column privileges apply to single columns in a given table. Each privilege to be granted at the column level must be followed by the column or columns, enclosed within parentheses. GRANT SELECT (col1), INSERT (col1,col2) ON mydb.mytbl TO 'someuser'@'somehost'; The allowable

limiting acess by Triggers

Hi all , Im new on mysql,how can block update column of specif table for a user "x" by trigger in mysql? Is possible deny acess for columns on mysql? version: 5.0.77 Regards

Queries not in Cache

Hello, I've activated the query_cache in Mysql with the variable "query_cache_limit" value to 1 MB. My question is: How to know what queries wasn't cached because they have exceeded the value of "query_cache_limit"? **Sorry for my Brazilian Englihs :( Thanks! -- MySQL General Mailing List For

HOW TO INSTALL MYSQL ODBC ON AIX 5.3 ?

FOLLOW ARE SOME MY OPERATOR STEPS,HOW WILL I TO DO IT? p570a:/mysql/mysql-connector-odbc-5.1.6-aix5.3-powerpc-64bit/bin >./myodbc-installer exec(): 0509-036 Cannot load program ./myodbc-installer because of the following errors: 0509-150 Dependent module libodbc.so could not be loaded.