mysql存储过程是否可以具有默认参数? [英] Is it possible to have a default parameter for a mysql stored procedure?

问题描述

我在Google上搜索并不断提出不，这是不可能的"，但是这些帖子的发布日期为2005-2007，所以我想知道是否已更改.一个代码示例:

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

解决方案之一是传递null，然后检查null并设置变量.我不想这样做，也不必这样做.如果这是真的，那么MySql开发人员需要唤醒，因为使用MSSQL可以做的事情还很多.

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.

推荐答案

仍然不可能.

这篇关于mysql存储过程是否可以具有默认参数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！