PostgreSQL function into MySQL

[Dana Zon]

Hi there,

I need to convert the following code from PostgreSQL into MySQL

Code:

CREATE TYPE type_name AS
(
field_id INTEGER,
field_name VARCHAR(50)
);


CREATE FUNCTION function_name()
RETURNS SETOF type_name LANGUAGE plpgsql AS $$
DECLARE
variable_name type_name;
BEGIN
FOR variable_name IN
SELECT field_id, field_name
FROM table_name
ORDER BY field_id
LOOP
RETURN NEXT variable_name;
END LOOP;
END;
$$;


SELECT * FROM function_name();


Can anybody help?


Thanks in advance!