title: MySQL - Cannot insert NULL value in column, but I have a default value specified?
body: <p>I have a table in MySQL that have a few columns that have default values specified, but when I try to insert a row, (not specifying values for those default columns), it throws an error saying I cannot insert NULL values.</p>
  
  <p>Here is the table example;</p>
  
  <pre><code>CREATE TABLE `users` (
    `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `UniqueName` varchar(120) NOT NULL,
    `Password` varchar(1000) NOT NULL,
    `PublicFlag` tinyint(1) NOT NULL,
    `NoTimesLoggedIn` int(10) unsigned NOT NULL DEFAULT '0',
    `DateTimeLastLogin` timestamp NOT NULL DEFAULT '1971-01-01 00:00:00',
    `UserStatusTypeId` int(10) unsigned NOT NULL,
    `Private` tinyint(1) NOT NULL DEFAULT '0',
    `SiteName` varchar(255) NOT NULL,
    `CountryId` int(10) NOT NULL DEFAULT '0',
    `TimeZoneId` varchar(255) NOT NULL DEFAULT 'UTC',
    `CultureInfoId` int(10) unsigned NOT NULL DEFAULT '0',
    `DateCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `UserCreated` int(10) unsigned NOT NULL,
    `LastUpdatedBy` int(10) unsigned NOT NULL,
    `DateLastUpdated` datetime DEFAULT NULL,
    PRIMARY KEY (`Id`),
    UNIQUE KEY `UniqueName_UNIQUE` (`UniqueName`),
    KEY `Index 3` (`SiteName`)
  )
  </code></pre>
  
  <p>It complains about TimeZoneId, and when I populate TimeZoneId, it complains about CultureInforId.</p>
  
  <p>I am using MySQL Version: 5.1.43-community</p>
  
  <p>Here is the insert query I am trying to insert, grabbed from NHibernate Profiler:</p>
  
  <pre><code>INSERT INTO Users
             (UniqueName,
              Password,
              PublicFlag,
              NoTimesLoggedIn,
              DateTimeLastLogin,
              SiteName,
              TimeZoneId,
              DateCreated,
              DateLastUpdated,
              Private,
              CountryId,
              CultureInfoId,
              UserCreated,
              LastUpdatedBy,
              UserStatusTypeId)
  VALUES     ('zma@zm.com','u1uhbQviLp89P9b3EnuN/Prvo3A4KVSiUa0=',1,
  0,'1/01/1971 12:00:00 AM','V9O1T80Q6D',NULL,'2/08/2010 2:13:44 AM',
  '2/08/2010 2:13:44 AM',0, NULL, NULL, 4, 4,31)
  </code></pre>