Stories
Slash Boxes
Comments

NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

use Perl

All the Perl that's Practical to Extract and Report

0000-00-00 vs NULL: Yet Another Reason to Hate MySQL More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

one problem I do not need to worry about (Score:1)

by link (3402)

Now that I use mysql at $work these mysql behaviour s worry me a lot more but at least this is one mysqlism I'm not likely to fall into. I do not expect to be counting nulls in a not null table.
- Re:one problem I do not need to worry about (Score:2)
  
  by bart (450) <bart.lateur@pandora.be> on 2007.03.10 7:31 (#53636) Journal
  
  Plus, in what way is '0000-00-00' a valid date? I can only see it as a (badly) stringified version of a NULL date. Thus, it should have been disallowed as an entry in this table. IMO it should be disallowed anywhere.
  
  Reply to This
  
  Parent
  - Re: (Score:1)
    
    by Adrian (66)
    
    '0000-00-00' is a valid "zero value" date in MySQL - see the docs [mysql.com] for the evil details.
    
    Needless to say - not my schema.

Get More Comments

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.