PostgreSQL into MySQL

Hi there,

I need to convert the following code from PostgreSQL into MySQL

Code:

 
[COLOR=darkred]CREATE TYPE type_name AS[/COLOR]
[COLOR=darkred]([/COLOR]
[COLOR=darkred]field_id INTEGER,[/COLOR]
[COLOR=darkred]field_name VARCHAR(50)[/COLOR]
[COLOR=darkred]);[/COLOR]
[COLOR=darkred][/COLOR] 
[COLOR=darkred][/COLOR] 
[COLOR=darkred]CREATE FUNCTION function_name()[/COLOR]
[COLOR=darkred]RETURNS SETOF type_name LANGUAGE plpgsql AS $$[/COLOR]
[COLOR=darkred]  DECLARE[/COLOR]
[COLOR=darkred]    variable_name type_name;[/COLOR]
[COLOR=darkred]  BEGIN[/COLOR]
[COLOR=darkred]    FOR variable_name IN[/COLOR]
[COLOR=darkred]      SELECT field_id, field_name[/COLOR]
[COLOR=darkred]      FROM table_name[/COLOR]
[COLOR=darkred]      ORDER BY field_id[/COLOR]
[COLOR=darkred]    LOOP[/COLOR]
[COLOR=darkred]      RETURN NEXT variable_name;[/COLOR]
[COLOR=darkred]    END LOOP;[/COLOR]
[COLOR=darkred]  END;[/COLOR]
[COLOR=darkred]$$;[/COLOR]
[COLOR=darkred][/COLOR] 
[COLOR=darkred][/COLOR] 
[COLOR=darkred]SELECT * FROM function_name();[/COLOR]

Can anybody help?

Thanks in advance!

 

From what I can tell MySQL doesn't support Types like PostgreSQL.

However you can use the SET datatype. Have a look at the MySQL manual (http://dev.mysql.com/doc/refman/5.1/en/set.html) for more detail

 

Thanks, but I found an alternative by creating mySQL procedures instead of functions.

Code:

CREATE PROCEDURE procedure_name()
BEGIN
SELECT fiend_id, field_name FROM table_name ORDER BY field_id;
END$$

Thanks anyway!

 

...and called it this way:

$sql = 'CALL procedure_name()';