Creating a procedure in mySql with parameters

Question

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

User · Answer

IN  brugernavn varchar 64       IN  password varchar 64     The problem is the

User · Answer

Its very easy to create procedure in Mysql  Here  in my example I am going to create a procedure which is responsible to fetch all data from student table according to supplied name   DELIMITER    CREATE PROCEDURE getStudentInfo IN s name VARCHAR 64   BEGIN SELECT   FROM student database student s where s sname   s name  END   DELIMITER    In the above example  database and table names are student database and student respectively  Note  Instead of s name  you can also pass  s name as global variable   How to call procedure  Well  its very easy  simply you can call procedure by hitting this command   mysql gt  CAll getStudentInfo  pass required name

User · Answer

I figured it out now  Here s the correct answer  CREATE PROCEDURE checkUser       brugernavn1 varchar 64      password varchar 64     BEGIN     SELECT COUNT    FROM bruger     WHERE bruger brugernavn brugernavn1     AND bruger pass password   END       points to a global var in mysql  The above syntax is correct

[mysql] Creating a procedure in mySql with parameters

Examples related to mysql

Examples related to parameters

Examples related to procedure