title: Creating SQL table where empty string on DATETIME or INT doesn't default
body: <p>How do I create a table so that an <code>INSERT INTO</code> with empty string doesn't default to Jan 1, 1900 for <code>DATETIME</code> data type, or 0 for <code>INT</code> data type?</p>
  
  <pre><code>CREATE TABLE TEST
  (
    TS DATETIME,
    VA INT
  )
  
  INSERT INTO TEST VALUES ('','')
  INSERT INTO TEST VALUES ('','2')
  INSERT INTO TEST VALUES ('2012-06-08 12:13:14','')
  
  SELECT * FROM TEST
  </code></pre>
  
  <p><a href="http://sqlfiddle.com/#!3/4fafb/1" rel="nofollow">SQL FIDDLE</a></p>