title: MySql Stored Procedure's parameter with the same name as affecting's column, is it possible?
body: <p>I have a sequence table with two columns, name, value, and I have a stored procedure for incrementing the value provided the name</p>
  
  <pre><code>DROP PROCEDURE IF EXISTS p_generate_sequence;
  delimiter |
  CREATE PROCEDURE p_generate_sequence (name VARCHAR(30))
  BEGIN
      START TRANSACTION;
      -- Variable "name" equal to column "name", how to reference?
      UPDATE sequences_table SET value = value + 1 WHERE name = name;
      SELECT value FROM sequences_table WHERE name = name;
      COMMIT;
  END |
  delimiter ;
  </code></pre>
  
  <p>Note the parameter is called "name".</p>
  
  <p>Is there any approach for using a parameter with the same name as the column name of the affected table?</p>
  
  <p><strong>NOTE:</strong> I'm not interested in change parameter's name, nor even column's name, just to know whether is it possible or not, and how.</p>