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 suppose

Problems using Binary Install on Mac OS 10.4.1

) - 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 = NOVA

Re: Problems using Binary Install on Mac OS 10.4.1

--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:41 AM

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

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 archives

Re: datetime ORDER BY is erred

| 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:51 AM, Elton

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: Elton [EMAIL

Re: datetime ORDER BY is erred

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 MySQL and am using what

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.1 cpu

Re: datetime ORDER BY is erred

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 upgrade 4.0.14, what file is correct: mysql-standard

Re: datetime ORDER BY is erred

) are not supported by this package. The package is located inside a disk image (`.dmg') file, that you first need to mount by double-clicking its icon in the Finder. It should then mount the image and display its contents. So, does this not say that I don't need both; just the pkg .dmg file? Elton

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 4.0.11, you can