Is there any way so we can return a table from a mySQL function?

Like we do on SQL SRV?

ALTER FUNCTION [dbo].[blablabla](

@grupo int,

@singular varchar(50),

@plural varchar(50),

@flag_e bit,

@s_ext varchar(255)

)

RETURNS @resultado TABLE (flag_e bit, s_ext varchar(250))

AS

BEGIN

DECLARE

This is SQL SRV, if possible i want a similar code but on MySQL.

Thanks in advance

EDIT

ok

[dbo].[blablabla] = returns @result TABLE

now in another function i need to

...

begin

...

select *

from dbo.blablabla(parameters)

...

end

this is code from SQL SRV, which i need to convert to MySQL

解決方案

No, MySQL functions can only return column data types.

However, your function can insert results into a table of a known name—including a (temporary) one created within the function body; alternatively, procedures (but not functions) can generate resultsets that are sent to the client (e.g. by executing a SELECT statement).

《新程序員》：云原生和全面數字化實踐50位技術專家共同創作，文字、視頻、音頻交互閱讀

總結

以上是生活随笔為你收集整理的mysql 返回mysql,mysql函数返回表的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。