C＃如何从mysql函数返回表？ [英] C# How to return table from mysql function?

问题描述

怎么可以从mysql函数返回数据表或表，例如我给参数，我想用该参数返回整个数据表，我发现视图不能有参数，我刚刚发现了函数，接受参数，但我不知道如何使函数返回表？

hi how is possible to return datatable or table from mysql function, for example I give parameter and I want to return the whole datatable with that parameter, I just found out that views cant have parameters and I just found about functions, which accepts parameters but I dont know how to make the function to return table?

推荐答案

尝试存储过程而不是函数。

A带参数的示例存储过程 -

Try a stored procedure rather than a function.
A sample stored procedure with parameter -

DELIMITER

DROP < span class =code-keyword> PROCEDURE IF EXISTS MyFirstSP

DROP PROCEDURE IF EXISTS MyFirstSP

CREATE PROCEDURE MyFirstSP（ IN Id INT ）
BEGIN
SELECT * FROM MyTable WHERE pk_id = Id;
END

CREATE PROCEDURE MyFirstSP(IN Id INT) BEGIN SELECT * FROM MyTable WHERE pk_id=Id; END

这篇关于C＃如何从mysql函数返回表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！