Alex Rivera | Logout

Creating a procedure in mySql with parameters

Asked 2011-02-18T08:59:15.087
50

I am trying to make a stored procedure using mySQL. This procedure will validate a username and a password. I'm currently running mySQL 5.0.32 so it should be possible to create procedures.

Heres the code I've used. All I get is an SQL syntax error.

   GO
    CREATE PROCEDURE checkUser
    (IN @brugernavn varchar(64)),IN @password varchar(64))
    BEGIN
    SELECT COUNT(*)  FROM bruger WHERE bruger.brugernavn=@brugernavn AND bruger.pass=@Password;
    END;

Thank you in advance

Edit
Report

1 Answer

8
(IN @brugernavn varchar(64)**)**,IN @password varchar(64))

The problem is the )

answered 2013-04-17T17:39:57.800

Your Answer