CREATE FUNCTION getResultSet(KEY INT) RETURNS RESULTSET BEGIN DECLARE resultSet RESULT_SET; SELECT * FROM myTable WHERE id = KEY; SET resultSet = SELECT * FROM myTable WHERE id = KEY; RETURN resultSet; END;
写一个mysql8函数,参数表主键,返回查询语句结果集
最新推荐文章于 2023-02-18 17:30:33 发布