title: How to validate user login using Procedure in MySQL?
body: <p>Currently i am working in validate user login, so using procedure to compare username and password to signupform table, then find a recordset value is >0 (success) or &lt;0 (failed), but i am not very well in procedure concept, i tried my level best but i can't fix this, please help me.
  Thanks in Advance</p>
  
  <p>Here i have tried this:</p>
  
  <pre><code>Create table signupform (username varchar(10), password varchar(10)); 
  Insert into signupform values ('sampath','s96000');
  Insert into signupform values ('yuvaraj','y96297');
  select * from signupform;
  
  // CREATE PROCEDURE for compare username and password
  create procedure testing (@username varchar(10), @password varchar(10))
  AS
  BEGIN
  select * from signupform where username = @username and password = @password
  End;
  </code></pre>