title: ER_NO_DEFAULT_FOR_FIELD in MySQL (nodejs rest request)
body: <p>what does this error mean in mysql?<br>
  ER_NO_DEFAULT_FOR_FIELD –  “Field doesn’t have a default value”
  I've found it listed here?
  <a href="http://mysqlserverteam.com/improvements-to-strict-mode-in-mysql/" rel="nofollow">http://mysqlserverteam.com/improvements-to-strict-mode-in-mysql/</a>
  and got:</p>
  
  <pre><code>{
      "code": "ER_NO_DEFAULT_FOR_FIELD",
      "errno": 1364,
      "sqlState": "HY000",
      "index": 0
  }
  </code></pre>
  
  <p>that reply in a postman request via expressjs, but this is the first table I've seem to have gotten it from.  the table has foreign keys so I set default values for the foreign keys, but I still get it.  what gives?  is the index[0] implying the name, the first json value I sent to the server?</p>
  
  <pre><code>{
      "name":"Cornwall Park Townhouses",
      "line1":"17 Brewster Rd.",
      "city":"Cornwall",
      "state":32,
      "zip":"12518",
      "category":2,
      "account_mgr":1,
      "active":1
  }
  </code></pre>
  
  <p>heres my json</p>