title: node-red, MySQL error
body: <p>Get an error when writing to the database</p>
  
  <p>The function for it:</p>
  
  <pre><code>var newMsg = { payload: msg.payload };
  newMsg.topic="insert into MyTable (a,b,c,d,e,f,g) values (newMsg.payload)"
  </code></pre>
  
  <p>The incoming payload debug shows</p>
  
  <pre><code>payload: "B0:AC:A2:AC:07:F4","Ready","893901","860990","online","876","333"
  </code></pre>
  
  <p>The error I get from the database node (nore-red-node-mysql) is</p>
  
  <blockquote>
    <p>"Error: ER_WRONG_VALUE_COUNT_ON_ROW: Column count doesn't match value
    count at row 1"</p>
  </blockquote>
  
  <p>The strange thing to me is that if I try a</p>
  
  <pre><code>newMsg.topic="insert into MyTable (a,b,c,d,e,f,g) values (\"B0:AC:A2:AC:07:F4\",\"Ready\",\"893901\",\"860990\",\"online\",\"876\",\"333\")" 
  </code></pre>
  
  <p>it works perfectly...</p>
  
  <p>Where is the trick?</p>