Is it possible to have a default parameter for a mysql stored procedure?

sql mysql stored-procedures default-value
aarona picture aarona · Jun 11, 2009 · Viewed 100.8k times · Source

I have googled this and keep coming up with "No it is not possible" but these posts were dated 2005-2007 so I'm wondering if this has been changed. A code example:

CREATE PROCEDURE `blah`
(
  myDefaultParam int = 0 -- This breaks the code for some reason
)
BEGIN
  -- Do something here
END

One of the solutions has been to pass null and then check for null and set the variable. I don't want to do that and I shouldn't have to. If this is true then MySql devs need to wake up because there is so much more I could do with MSSQL.

Answer

Paul Sonier picture Paul Sonier · Jun 11, 2009

It's still not possible.

Related questions

MySQL: Selecting multiple fields into multiple variables in a stored procedure

Can I SELECT multiple columns into multiple variables within the same select query in MySQL? For example: DECLARE iId INT(20); DECLARE dCreate DATETIME; SELECT Id INTO iId, dateCreated INTO dCreate FROM products WHERE pName=iName; What is the correct syntax …

Read More
Mysql - How to quit/exit from stored procedure

I have very simple question but i did't get any simple code to exit from SP using Mysql. Can anyone share with me how to do that? CREATE PROCEDURE SP_Reporting(IN tablename VARCHAR(20)) BEGIN IF tablename IS NULL THEN #…

Read More
MySQL : transaction within a stored procedure

The basic structure of my stored procedure is, BEGIN .. Declare statements .. START TRANSACTION; .. Query 1 .. .. Query 2 .. .. Query 3 .. COMMIT; END MySQL version: 5.1.61-0ubuntu0.11.10.1-log Currently, if 'query 2' fails, result of 'query 1' is committed. How can I rollback the transaction …

Read More