mysql - 如何获取存储过程结果以用于另一个存储过程或查询语句

Question

我正在尝试创建一个存储过程，其中过程内部是一个查询语句，其结果将用作另一个查询的参数

CREATE DEFINER=`root`@`localhost` PROCEDURE `getRecActive`(
IN  adminid VARCHAR(25))
BEGIN
   select record_id from records2 where record_div = @adminid
   //i want to use record_id result to the next query
   select * from records where record = "record_id";
END

Answer 1

select * from records 
where record in
(
  select record_id from records2 where record_div = @adminid
)