Errors caused by the same passing parameters of stored procedures and field attributes in the table _ MySQL

The parameter passed in the stored procedure is the same as the field attribute in the table, leading to the error bitsCN.com
The passing parameters of the stored procedure are the same as the field attributes in the table, causing errors. a colleague writes the stored procedure and passes the parameters in the stored procedure. the passing parameters are the same as the attributes of a field in the table: as shown in the following figure, the where condition is always true due to the red part, and name = name causes an error. The passed parameters must be different from the fields in the table. Author: aeolus_pubitsCN.com