title: Error Code: 1136. Column count doesn't match value count at row 1 (I know what does it mean)
body: <p>I am creating a stored procedure that uses this code in MYSQL:</p>
  
  <pre><code>DECLARE id_historico_adscripciones_personal int;
  
  SET @id_historico_adscripciones_personal = (select max(id) from historico_adscripciones_personal)+1;
  
  INSERT INTO historico_adscripciones_personal(id,id_empleado,id_estatus_historico,id_estatus,id_rme_o_dep,sueldo,moneda,observaciones,fecha_creacion,fecha_actualizacion values(@id_historico_adscripciones_personal,@id_empleado_o,@id_estatus_historico_o,5,@id_rme_o_dep,@sueldo_o,@moneda_o,@observaciones_o,now(),now());
  </code></pre>
  
  <p>I get the following error from MYSQL:</p>
  
  <pre><code>Error Code: 1136. Column count doesn't match value count at row 1
  </code></pre>
  
  <p>I know what that means, the topic here is that if  in the code above I change after the word values @id_historico_adscripciones_personal by a number (i.e: 71)</p>
  
  <pre><code> INSERT INTO historico_adscripciones_personal(id,id_empleado,id_estatus_historico,id_estatus,id_rme_o_dep,sueldo,moneda,observaciones,fecha_creacion,fecha_actualizacion) values(71,@id_empleado_o,@id_estatus_historico_o,5,@id_rme_o_dep,@sueldo_o,@moneda_o,@observaciones_o,now(),now());
  </code></pre>
  
  <p>I dont get the error message. I've already tested the <code>SET</code> procedure and everything seems to be OK. </p>