Declaring variables in MySQL 5 Stored Procedure

I would like to avoid specifying the exact type and column length of a variable in a stored procedure when using cursors.  For example, instead of declare vendorNbr varchar(16),
I want to use a feature like Oracle has:  declare vendornbr ap_data.vendorNbr%TYPE;   This will make maintenance easier for when column lengths change.  Does anyone know whether such a feature exists?
lhalkapeelAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
SqueebeeConnect With a Mentor Commented:
I have not seen such a syntax yet in the documentation. You may wish to log a request at bugs.mysql.com.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.