CODEWITHSUNDEEP
mysql
Lý Thành Trung
Lý Thành Trung

Reputation: 5

How to Use Procedure in mysql

Help me fix error create PROCEDURE, thank you.

CREATE PROCEDURE USP_Login(IN AuserName VARCHAR(100),IN ApassWork VARCHAR(100))
BEGIN
    SELECT * FROM Account 
    WHERE UserName = AuserName AND PassWord = ApassWork;
END;

Upvotes: 0

Views: 64

Answers (3)

iamsankalp89
iamsankalp89

Reputation: 4739

Need to add DELIMITER // as it is MYSQL

DELIMITER //

 -- Procedure statment
//DELIMITER ;

Upvotes: 0

Sonam Tripathi
Sonam Tripathi

Reputation: 183

you need to define the mysql delimiter,since you have use delimiter ';' more than one place. Use the delimiter command as

DELIMITER //
CREATE PROCEDURE USP_Login(IN AuserName VARCHAR(100),IN ApassWork VARCHAR(100))
BEGIN
    SELECT * FROM Account 
    WHERE UserName = AuserName AND PASSWORD = ApassWork;
END //
DELIMITER ;

Please refer Defining Stored Programs

Upvotes: 1

Gimhani
Gimhani

Reputation: 1375

Since you have a ; in the middle of your procedure as well, change delimiter for just creating the procedure as this and change it again.

DELIMITER //
CREATE PROCEDURE USP_Login(IN AuserName VARCHAR(100),IN ApassWork VARCHAR(100))
BEGIN
    SELECT * FROM Account 
    WHERE UserName = AuserName AND PassWord = ApassWork;
END//
DELIMITER ;

Upvotes: 2

Related Questions