[Rama]

Hi there,

I need to convert the following code from PostgreSQL into MySQL

 
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!