函数代码如下:CREATE FUNCTION get_results(IN pk INT) RETURNS TABLE ( result VARCHAR(255) ) BEGIN DECLARE stmt VARCHAR(255); SET stmt = CONCAT('SELECT * FROM table WHERE primary_key = ', pk); PREPARE stmt FROM @stmt; EXECUTE stmt; DEALLOCATE PREPARE stmt; RETURN; END
写一个mysql8函数,参数表主键,返回查询语句结果集,不报1064错误
最新推荐文章于 2024-06-09 19:26:27 发布