Search code examples
mysqlmathevalformulastored-functions

How do I eval a simple math formula inside a MySQL stored _function_?

Inside my stored function I have :

formula := "(10+10 * 1000)/12";

(a simple math formula, with numbers only, dynamically created as a string)

How do I eval this, and return the result ?

I can't use EXECUTE (not possible inside a stored function) and if I make it a stored procedure and call it from a stored function, I get "Dynamic SQL is not allowed in stored function or trigger" -as if I would have the eval directly inside the function. I need a stored function, and not a procedure, because I need to call it inside a SELECT statement.

Solution

  • Apparently there is no solution to this. I have applied a "paintfull" workaround in PHP, which I will not display here as it is not the subject of the question.