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

more mysql things that make you go hmmm 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.

Re: more mysql things that make you go hmmm (Score:2)

by davorg (18)

This isn't fixed in MySQL 5. I've just been fighting the same problems.

The solution, it seems, is to put the database into strict mode [mysql.com]. The description includes this:
Make MySQL behave like a "traditional" SQL database system. A simple description of this mode is “give an error instead of a warning” when inserting an incorrect value into a column.

But I can't understand why anyone would possibly want a database to not behave in the traditional manner.
- one "word" (Score:1)
  
  by rjbs (4671)
  
  backcompat :(
  
  --
  rjbs
  - Re:one "word" (Score:2)
    
    by davorg (18) <dave@dave.org.uk> on 2007.06.26 5:06 (#55773) Homepage Journal
    
    backcompat :(
    
    Which, of course, wouldn't have been a problem if they'd done it properly in the first place.
    
    Reply to This
    
    Parent

Get More Comments

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