MySQL Forums
Forum List  »  Stored Procedures

Re: No Dynamic SQL in Function or Trigger Frustration
Posted by: Peter Brawley
Date: March 14, 2014 07:43PM

> 1. How difficult is it to re-write a local version of MySQL from source to actually permit this feature to function?

Very, even if you're an accomplioshed C++ programmer.

> To jump between C, C#, VB, PHP, Python or anything else to do this would increase runtime to anywhere in the #Nth millions of years to run til completion

What's the point of such hyperbole? Developers implement calculations of the sort you describe every day in app languages like PHP.

> The base tables for my query applies a combination of tables. 4 to be precise, using 5 columns in each to set 20 possible values.

> For each string of 20 I intend to account for spreads and statistical offsets between the various numbers when applied as a matrice [sic]

SQL is set-based, so it isn't an optimal tool for large-matrix calculations like that. Are you sure you shouldn't be using something like R?

Options: ReplyQuote

Written By
Re: No Dynamic SQL in Function or Trigger Frustration
March 14, 2014 07:43PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.