title: Yet another MySQL syntax error
body: <p>This isn't something I usually have problems with but I don't understand that one now. I tried with backticks, with double quotes, without backticks,...</p>
  
  <p>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7</p>
  
  <pre><code>CREATE PROCEDURE mapping(
      p_object INT(10),
      brand VARCHAR(255),
      model VARCHAR(255))
  BEGIN
      INSERT INTO `object_brand_model_mapping`
      SET `object`=p_object, `brandNameNormalized`=brand, `modelNameNormalized`=model;
  END;
  </code></pre>
  
  <p>I also tried</p>
  
  <pre><code>INSERT INTO `object_brand_model_mapping`
      (`object`, `brandNameNormalized`, `modelNameNormalized`)
  VALUES
      (p_object, brand, model);
  </code></pre>
  
  <p>which produces exactly the same error.</p>
  
  <p>I don't know what's wrong with this. Do any special rules apply to <code>INSERT</code> in a procedure?</p>
  
  <p>All of the columns do exist.</p>