Re: Optimising a query on a large table.

e pointers. Merry Christmas. Rob Keeling "Donny Simonton" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Rob, > First of all I would say, your query is pretty badly laid out. First, > unless you need every fields from a table returned only ask for those > spe

Re: Optimising a query on a large table.

"kernel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Rob, > Have you run "show full processlist;" to see if it is copying to a tmp > table ?? > > walt Nothing listed other than the query itself. Should have said its on Mysql 3.21. Rob K

Optimising a query on a large table.

LIKE 10) AND (session_start > '2004-09-01 00:00:00') AND (session_start < '2004-10-01 00:00:00') Order by session_start Thanks Rob Keeling - -- I love deadlines. I love the whooshing noise they make as they go by. - Douglas Adams -- MySQL General Mailing Li

sql query to return unique ids from a table of date stamped results

, however I need to be able to just pick out the row with the latest Lastupdatetime for each ADNO. I couldn`t find anything on google, but may have been asking the wrong question! Any help greatly appreciated. Rob Keeling -- -- I love deadlines. I love the whooshing noise they make as they go by

Bulk addition of users and databases

to allow students to try out mysql querys with phpmyadm etc) Any suggestions? Thanks Rob Keeling -- -- I love deadlines. I love the whooshing noise they make as they go by. - Douglas Adams -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Linking Mysql tables across databases

). I know I can do this with MS access, but can I do it in a proper database? Thanks Rob Keeling -- -- I love deadlines. I love the whooshing noise they make as they go by. - Douglas Adams -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe