是否可以为 mysql 存储过程设置默认参数?

2021-11-20 00:00:00 sql default-value mysql stored-procedures

我在谷歌上搜索了这个并不断提出不，这是不可能的"，但这些帖子的日期是 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.

推荐答案

还是不行.

相关文章