MySQL - stored procedure returns unexpected value

Question

I wrote a stored procedure(MySQL) that should return all user's data by user's email. Here is my stored procedure:

-- Change Delimiter
DELIMITER //
-- Create Stored Procedure
CREATE DEFINER=`username`@`localhost` PROCEDURE GetUserByEmail( 
    IN Email VARCHAR(255)
)
BEGIN

SELECT * FROM user WHERE email = Email;

END//
-- Change Delimiter again
DELIMITER ;

However, instead of returning all data only for the user with specified email, it returns all user table. And when I run the same query without stored procedure it returns only data for the user with specified email. Here is the query:

SELECT * FROM user WHERE email = '[email protected]';

nacho · Accepted Answer · 2017-08-22 13:59:15Z

1

That´s because email it´s allways = to Email (the column names are not case sensitive) You should change it to something like this:

-- Change Delimiter
DELIMITER //
-- Create Stored Procedure
CREATE DEFINER=`username`@`localhost` PROCEDURE GetUserByEmail( 
    IN My_email VARCHAR(255)
)
BEGIN

SELECT * FROM user WHERE email = My_email;

END//
-- Change Delimiter again
DELIMITER ;

answered Aug 22, 2017 at 13:59

nacho

5,3772 gold badges28 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL - stored procedure returns unexpected value

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related