Bug #15813 Feature Request for Named Parameters in the CALL statement
Submitted: 16 Dec 2005 16:32 Modified: 27 Nov 2009 12:58
Reporter: Jay Pipes Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S4 (Feature request)
Version:5.0+ OS:Any (All)
Assigned to: CPU Architecture:Any

[16 Dec 2005 16:32] Jay Pipes 
Description:
Hi guys,

See http://forums.mysql.com/read.php?98,59973 for a description of the feature request.  I think this would be an excellent feature to have, especially for those SQL Server types looking for similar functionality.  Indeed, for procedures operating on many-columned tables, this would be very handy indeed.

Cheers,

Jay

How to repeat:
Not supported.  Feature request...
[17 Nov 2006 20:05] Evan K 
This would be a very useful feature.  Right now, I have stored procs with roughly 50 parameters, many of which dont ever change.  Seeing (and writing) this:
proc(param5='abc', param12='xyz')

would be much better than this:
proc(NULL, NULL, NULL, NULL, 'abc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'xyz')

I'm thinking of moving said project over to postgresql because its just getting too complex for mysql to handle like this.
[27 Nov 2009 12:58] Valeriy Kravchuk 
Thank you for the feature request. Oracle's PL/SQL also has this very useful feature.
[26 Dec 2016 20:11] Kyle Hooks 
For the love of God would you implement this already?