|
Posted by Ike on January 24, 2006, 2:18 pm
Please log in for more thread options
Why would some innodb's not take a 'no null' for a field? Has anyone
experienced anything like this? -Ike
|
|
Posted by Ike on January 24, 2006, 2:51 pm
Please log in for more thread options
yet, when I export the table, I get:
CREATE TABLE `leads` (
`id` int(11) NOT NULL auto_increment,
`uniqueId` varchar(40) default NULL,
`upcardkey` int(11) NOT NULL default '0',
`associatekey` int(11) NOT NULL default '0',
`date` varchar(16) default NULL,
`time` varchar(11) default NULL,
`sensor` int(3) NOT NULL default '0',
`heads` int(3) NOT NULL default '1',
`upskey` int(11) NOT NULL default '0',
`closed` int(3) NOT NULL default '0',
`howdidyouhear` int(11) NOT NULL default '0',
`bb` int(3) NOT NULL default '0',
`tor` int(3) NOT NULL default '0',
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
So evidently NOT NULL is taking...yet, when I look at the table structure
under phpMyAdmin 2.6.1-pl3
the NULL column for each field shows as 'Yes.'
Something is amiss here. -Ike
|
| Similar Threads | Posted | | MySQL 4.0.17 data scrambles, not-null fields become null, etc. | July 3, 2006, 3:38 pm |
| lots of time taking when inserting 1000 records | July 26, 2006, 2:25 am |
| not null column with null defaults | July 29, 2006, 1:00 am |
| Null Value | August 31, 2005, 1:35 pm |
| LIKE and IS NOT NULL | February 1, 2006, 2:28 am |
| Really going crazy with NOT NULL | January 24, 2006, 3:44 pm |
| sort NULL last | October 27, 2006, 12:17 am |
| Checking a field for NULL | February 13, 2006, 3:05 pm |
| Entering NULL from a form | February 23, 2006, 12:43 pm |
| NULL and zero-length string | March 4, 2006, 5:09 am |
|
XML Sitemap