The Count result of the MySQL stored procedure is incorrect.

I have been learning PHP for this holiday and will inevitably use the MySQL database. I used the stored procedure and encountered a small problem. I did not solve a lot of problems I found on the Internet. Then I discovered this. Alas, beginners struggle.

Problem:UsernameVarchar (50 ),PassVarchar (500)

 

Declare C int;
Select count (*) into C from user where pass =Pass And username =Username;

Number of all records displayed

Solution:

NameVarchar (50 ),Oldpass Varchar (500)

 

Declare C int;
Select count (*) into C from user where pass =OldpassAnd username =Name;

This is correct !!!

 

Found? Pay attention to the upper and lower green part, the originalMySQL is case insensitive.That is to say, the username and username are the same. Of course, the where condition is always correct. Haha... I hope you will pay attention to it.