RE: RE: what is the proper way to store timezone information?

2008-06-16 Thread Boyd, Todd M.
> -Original Message- > From: Per Jessen [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 14, 2008 6:23 AM > To: mysql@lists.mysql.com > Subject: RE: what is the proper way to store timezone information? > > Boyd, Todd M. wrote: > > >> > >> When

RE: natural sort via substrings

2008-06-13 Thread Boyd, Todd M.
From: Jim Lyons [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2008 12:10 PM To: Boyd, Todd M. Subject: Re: natural sort via substrings What I would do is form 2 additional fields from the first, an alphanumeric field and a numeric field so: jane-2   jane- 2 alex 3   alex  3

RE: natural sort via substrings

2008-06-13 Thread Boyd, Todd M.
> -Original Message- > From: Emily Heureux [mailto:[EMAIL PROTECTED] > Sent: Friday, June 13, 2008 11:12 AM > To: Boyd, Todd M.; mysql@lists.mysql.com > Subject: RE: natural sort via substrings > > Hi, I am sorry for being so vague. The values are not as simple as &

RE: query counts of a database

2008-06-13 Thread Boyd, Todd M.
> -Original Message- > From: Elim Qiu [mailto:[EMAIL PROTECTED] > Sent: Friday, June 13, 2008 10:56 AM > To: mysql@lists.mysql.com > Subject: query counts of a database > > I'm looking for a query that reports the count of each table in the > database. > the query should not assume the tab

RE: Fulltext index -first query slow, subsequent queries fast

2008-06-13 Thread Boyd, Todd M.
> -Original Message- > From: Ananda Kumar [mailto:[EMAIL PROTECTED] > Sent: Friday, June 13, 2008 10:48 AM > To: [EMAIL PROTECTED] > Cc: mos; mysql@lists.mysql.com > Subject: Re: Fulltext index -first query slow, subsequent queries fast > > Hi > > Is sphinxsearch avialable only on for win

RE: natural sort via substrings

2008-06-13 Thread Boyd, Todd M.
> -Original Message- > From: Boyd, Todd M. [mailto:[EMAIL PROTECTED] > Sent: Friday, June 13, 2008 10:33 AM > To: Emily Heureux; mysql@lists.mysql.com > Subject: RE: natural sort via substrings ---8<--- snip > Forgive me if I am incorrect, but wouldn't "ja

RE: what is the proper way to store timezone information?

2008-06-13 Thread Boyd, Todd M.
> -Original Message- > From: Per Jessen [mailto:[EMAIL PROTECTED] > Sent: Friday, June 13, 2008 5:17 AM > To: mysql@lists.mysql.com > Subject: what is the proper way to store timezone information? > > All, > > I will be recording timezone information based on user input using the > time z

RE: natural sort via substrings

2008-06-13 Thread Boyd, Todd M.
> -Original Message- > From: Emily Heureux [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 12, 2008 8:25 PM > To: mysql@lists.mysql.com > Subject: natural sort via substrings > > Hi, I am attempting to do a "natural sort" from within mysql, if > possible. > So, for example, jane2 would co

RE: Function Still Not Working

2008-06-13 Thread Boyd, Todd M.
> -Original Message- > From: Jesse [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 12, 2008 1:40 PM > To: Martijn Tonies; MySQL List > Subject: Re: Function Still Not Working > > > Any difference in default collation? > > Not sure what that is. I'm using a visual tool (EMS) to create my

RE: enable and disable keys

2008-06-12 Thread Boyd, Todd M.
From: Ananda Kumar [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2008 10:27 AM To: Boyd, Todd M. Cc: mysql Subject: Re: enable and disable keys /tmp has 16GB free space On 6/12/08, Boyd, Todd M. <[EMAIL PROTECTED]> wrote: > -Original Message- > From: Ananda Kumar [m

RE: enable and disable keys

2008-06-12 Thread Boyd, Todd M.
> -Original Message- > From: Ananda Kumar [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 12, 2008 9:41 AM > To: [EMAIL PROTECTED] > Cc: mysql > Subject: Re: enable and disable keys > > We have 200GB of free space on the file system where our database is > located. > ---8<--- snip If t

RE: Function Still Not Working

2008-06-12 Thread Boyd, Todd M.
> -Original Message- > From: Martijn Tonies [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 12, 2008 6:23 AM > To: MySQL List > Subject: Re: Function Still Not Working > > Hey, > > > Sorry for posting this again, but I got only one response last time, > and > I'm > > still having the pro