1、查询存储过程:
创建查询出point 大于数
DELIMITER //
CREATE PROCEDURE math_point(IN p_in int)
BEGIN
SELECT * from nc_users where point>p_in;
END;
//
DELIMITER ;
调用存储过程:
SET @p_in= 120 ; //积分值
CALL math_point(@p_in);
2、条件查询:
查询名称为空 或者 名称有值
DELIMITER //
CREATE PROCEDURE select_user_name(IN user_name varchar(20))
BEGIN
if user_name is not null
then select * from nc_users where `name` = user_name;
else select * from nc_users ;
end if ;
END;
//
DELIMITER ;
查询:
SET @user_name_in= null ;
CALL select_user_name(@user_name_in);
或者
SET @user_name_in= "小黑兔" ;
CALL select_user_name(@user_name_in);