title: MySQL insert NULL instead of 0000-00-00 date
body: <p>I have birthday column as a date defined in my table. When i insert a person and left blank birthday field, i get 0000-00-00 and i want to get NULL values. when i insert date as birthday i get date, which is fine.</p>
  
  <p>i tried :</p>
  
  <pre><code>Create table (
  birthday DATE NULL,
  birthday DATE DEFAULT NULL,
  birthday DATE NULL DEFAULT NULL,
  );
  </code></pre>
  
  <p>doesn't work, please a little advice to get NULL instead of 0000-00-00 in my birthday fields.
  my php script:</p>
  
  <pre><code>$q = "INSERT INTO users (birthday, other_column, data_registration) VALUES ('$birthday', '$other_column', NOW())
  </code></pre>
  
  <p>i get no solution yet, any ideea please?</p>