So cake considers 0 as default value for an integer isn't it ? On 23 mai, 15:44, "Davide" <[EMAIL PROTECTED]> wrote: > Chris Hartjes wrote: > > Perhaps I'm wrong, but last I checked you can't set an integer to > > NULL...the default for an integer would be zero, wouldn't it? > > on MySQL 4.1.14-nt (Windows XP) > > CREATE TABLE `xyz` ( > `field1` int(11) default NULL, > `field2` int(11) default NULL > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 > > mysql> insert into xyz (field2) value (1); > Query OK, 1 row affected (0.00 sec) > > mysql> select * from xyz; > +--------+--------+ > | field1 | field2 | > +--------+--------+ > | NULL | 1 | > +--------+--------+ > 1 row in set (0.00 sec) > > I had the doubt too :) > > Bye > Davide
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
