Page 1 of 1

Convert postgresql functions to mysql

Posted: Sat May 03, 2014 9:27 pm
by barb woolums
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

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;