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).