MySQL Forums
Forum List  »  Knowledge Base

Decoding of the column param_list in mysql.proc
Posted by: Martin Teefy
Date: November 26, 2009 12:37PM

Hi,

In mysql 6.0 you can use the information_schema.parameters table to get all the info you need about the parameters for a stored procedure as per other db engines like sql-server but in the lower versions (5*) you need to decode the param_list column in mysql.proc table but how?

In the mysql query browser this field has a little binocular icon for you to expand the contents of this column to see the contents in a new window, here you can see the binary info and the DECODED text equivalent on the right i.e. IN Parameter1 Integer, In Parameter2 varchar(10)

So what is the method of decoding this Blob column?

How did the authors of the browser do this - is there a function to call or an algorithm to use to allow me to decode the binary?

Thanks
Martin

Options: ReplyQuote


Subject
Views
Written By
Posted
Decoding of the column param_list in mysql.proc
3543
November 26, 2009 12:37PM


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.