用Navicat创建MySQL存储过程（二

1.使用Navicat for Mysql工具创建存储过程步骤：

点击查询右键新建查询

下面是查询编译器的sql语句：

DELIMITER $
DROP PROCEDURE if EXISTS selectLoginUser;
CREATE PROCEDURE selectLoginUser(IN userName VARCHAR(50),IN userPassWord VARCHAR(50),OUT result INT)
BEGIN
	SELECT * FROM account_table where Account_username = userName AND Account_password = userPassword;
	SELECT count(Account_id) FROM account_table INTO result;
	END $
DELIMITER;
 
CALL selectLoginUser("123","12345",@result);
SELECT @result;

好了，查询主要是会语法和sql语句，自己注意格式的编写，祝大家越来越牛