Parameters of the MySql stored procedure with the same name as the influence column, is this possible?

Question

I have a sequence table with two columns, name, value, and I have a stored procedure to increment the value, provided that the name

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 ; 

Note that this parameter is called "name".

Is there any approach for using a parameter with the same name as the table column name?

NOTE: I am not interested in the name of the change parameter or even the name of the column, just to find out if this is possible or not, and how.

Answer 1

Yes, specify your table column with an alias.

eg.

 delimiter // create procedure foo( id int ) begin select * from users u where u.id = id; end // call foo( 123 ) 

returns user id = 123