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 -~----------~----~----~----~------~----~------~--~---
