Optimizing nullable expiration dates

I've got a table that tracks expiration dates. Currently, if the record hasn't expired, the column is stored as NULL. In order to find records that haven't expired, I search for "WHERE expire_at > NOW() OR expire_at IS NULL". This seems dirty, and I suspect it makes my indexes very angry. I suppos

Re: Problems using Binary Install on Mac OS 10.4.1

afe --datadir=/usr/ local/mysql/ 26615 p1 U+ 0:00.00 grep mysqld -> I will check some more of the suggestions on that webpage. I am also curious about mysql.sock. I understand its function, but I do not understand its installation. Thank you for your help. Elton On Jun 15, 2005, at 10

Problems using Binary Install on Mac OS 10.4.1

tmp/mysql.sock' (2) -> Should the installer have installed mysql.sock in /tmp on Macs running OS 10.4.1? Is there a step I missed or is missing in the documentation? Can MySQL run on a Mac using 10.4.1? Thank you for your time. Elton =

RE: Erroneus column using MAX() and GROUP BY

keys, but I am still new to MySQL and this might need to be tweaked to work right. I hope it helps, or gets you moving in a better direction. Elton Clark Project Engineer IMET Corporation 82 Walker Lane, Suite 100 Newtown, PA 18940 215-860-6081 x5 [EMAIL PROTECTED] -Original Message

Upgrade packaged MySQL

Any advice for upgrading MySQL when it came packaged with a commercially available code (iTracker by Newark Electronics)? -Elton WindowsNT

Re: datetime ORDER BY is erred

Thanks Joakim and to all who have helped me on this topic; all is working properly under 4.0.16. Elton On Dec 1, 2003, at 6:48 PM, Joakim Ryden wrote: On 12/1/03 4:42 PM Elton wrote: Joakim, The "mysql-standard-4.0.16.dmg" installer release notes says, "Beginning with MySQL

Re: datetime ORDER BY is erred

don't need both; just the pkg .dmg file? Elton On Dec 1, 2003, at 6:00 PM, Joakim Ryden wrote: On 12/1/03 3:50 PM Elton wrote: If I'm installing on Panther_Server, to upgrade 4.0.14, what file is correct: mysql-standard-4.0.16 mysql-standard-4.0.16-apple-darwin6.6-powerpc.tar Both. The tar

Re: datetime ORDER BY is erred

16-apple-darwin6.6-powerpc.tar" looks very complicated -- are these files required to upgrade from 4.0.14 that was pre-installed on Panther_server? Elton On Dec 1, 2003, at 6:00 PM, Joakim Ryden wrote: On 12/1/03 3:50 PM Elton wrote: If I'm installing on Panther_Server, to upgr

Re: datetime ORDER BY is erred

If I'm installing on Panther_Server, to upgrade 4.0.14, what file is correct: mysql-standard-4.0.16 mysql-standard-4.0.16-apple-darwin6.6-powerpc.tar Elton On Dec 1, 2003, at 5:37 PM, Elton wrote: I downloaded a the 4.0.16 from mysql.com (a .dmg file), ran the installer on my local 10.3.

Re: datetime ORDER BY is erred

ay, I tested the "datetime ORDER BY error"; was not existent in 4.0.16. Elton On Dec 1, 2003, at 5:24 PM, Chris Waskowich wrote: On Dec 01, 2003, at 14:35, Elton wrote: So, maybe it was a bug that was fixed in 4.0.16; how do I upgrade to v4.0.16? I'm sort of a novice with MyS

Re: datetime ORDER BY is erred

So, maybe it was a bug that was fixed in 4.0.16; how do I upgrade to v4.0.16? I'm sort of a novice with MySQL and am using what was pre-installed with Apple's Panther_server -- have never installed it myself. Elton On Dec 1, 2003, at 1:18 PM, Victoria Reznichenko wrote: Elt

Re: datetime ORDER BY is erred

:00:00 | GII | MSL - FLL | | 2003-09-12 17:42:29 | GII | NYC - MSL | | 2003-10-01 11:00:02 | GII | FLL - MSL | +-+--+---+ 3 rows in set (0.00 sec) mysql> Which is wrong. Again, any advise would be appreciated. Elton On Dec 1, 2003, at 10

datetime ORDER BY is erred

I'm using MySQL v4.0.14 that ships with Panther_Server. I have been trying to get it to sort datetime fields properly without success; this is what I get: Is this a known bug? Is there a workaround? Any help would be appreciated. Elton -- MySQL General Mailing List For list arc