Re: Query: Order for the Earliest Latest date

2006-01-24 Thread Greg Fortune
In addition to the id_Site, you also need to grab the MAX(Time) so you have something to sort by. This requires a little trick known as a "groupwise maximum." See http://dev.mysql.com/doc/mysql/en/example-Maximum-column-group-row.html for an explanation and some examples. Greg F

Re: problems with old isam tables

2006-01-12 Thread Greg Fortune
Also, you may find that check table/repair table are able to fix the problem. See http://dev.mysql.com/doc/mysql/en/Table_maintenance.html for more information. Greg On Thursday 12 January 2006 08:28, Greg Fortune wrote: > That looks a little odd. Do isam tables have a .myi file for e

Re: problems with old isam tables

2006-01-12 Thread Greg Fortune
file. When upgrading between major versions (4.0, 4.1, 5.0, 5.1, etc), it's always wise to make a full backup of the data files and a full backup of the database using mysqldump. The output from mysqldump is just SQL so it is always the safest route if you run into problems. Greg Fortun

Re: Make a report like this...

2005-07-20 Thread Greg Fortune
You might try --xml or --html with a different separator. Greg -- Greg Fortune Enterprise Systems Eastern Washington University Phone: 509-359-6690 Email: [EMAIL PROTECTED] On Wednesday 20 July 2005 03:28 pm, Dan Bolser wrote

Re: remove trailing character

2005-03-10 Thread Greg Fortune
How about UPDATE table set email = TRIM(TRAILING '>' FROM email) http://dev.mysql.com/doc/mysql/en/string-functions.html Greg Fortune On Thursday 10 March 2005 03:29 pm, Scott Haneda wrote: > I managed to mess up and email storage addresses are in the format of > [EMAIL PR

Re: what is select_limit (and what is it used for)?

2005-03-07 Thread Greg Fortune
oduct joins that output millions of lines of data. Greg Fortune On Monday 07 March 2005 10:48 am, Caron, Christian wrote: > Hi, > > the default "select_limit" is set to 1000. What does this mean and how can > it affect a server? > > Is there some information out there

Re: Join Limits

2005-03-07 Thread Greg Fortune
Any chance of condensing some of the flag fields into bit fields? Alternatively, can you represent the variables as (rule id, variable name, variable value) in a single table rather than using lots of columns/tables? Greg Fortune On Monday 07 March 2005 10:31 am, Kevin Cowley wrote

Re: key on the month portion of a date field

2005-02-09 Thread Greg Fortune
Remember, a low cardinality index will possibly be ignored by the optimizer and an index on month will never have a cardinality of more than 12. For testing purposes, you might try added a column for month and populating it off your current data. update the_table set the_field=MONTH(the_field)

Re: Need more info about currently running queries

2004-12-21 Thread Greg Fortune
> and look for the thread state, but that's more related to the kernel stuff. > > See: > > http://dev.mysql.com/doc/mysql/en/SHOW_PROCESSLIST.html > > Greg Fortune <[EMAIL PROTECTED]> wrote: > > Is there anyway to get additional information about a query t

Need more info about currently running queries

2004-12-20 Thread Greg Fortune
ay to get at this kind of info? Greg -- Greg Fortune Enterprise Systems Eastern Washington University Phone: 509-359-6690 Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]