Convert postgresql functions to mysql
Posted: Sat May 03, 2014 9:27 pm
I can't find any conversion tools that will convert postgresql functions/stored procedures to mysql.
Has anyone achieved this in some way?
My functions are very simple like below, but I have 100s of them so need a way to do in bulk, even if it's by copying and replacing text in the dump file
Has anyone achieved this in some way?
My functions are very simple like below, but I have 100s of them so need a way to do in bulk, even if it's by copying and replacing text in the dump file
Code: Select all
CREATE OR REPLACE FUNCTION query_add_added_to_recipe(date, bigint)
RETURNS void AS
'update recipe set added = $1 where id=$2'
LANGUAGE sql VOLATILE
COST 100;