SQL 错误 1630:函数 SUBSTRING 不存在.. 是吧?

2021-12-20 00:00:00 mysql stored-procedures

没错.所以我在 MySQL 数据库中创建了一个存储过程，它恰好使用了 SUBSTRING.

Right. So I've created a stored procedure in a MySQL DB which happens to use SUBSTRING.

通过查询运行该过程给了我:

Running the procedure via a query gives me:

SQL 错误 1630:函数 mydatabase.SUBSTRING 不存在

SQL Error 1630: Function mydatabase.SUBSTRING does not exist

请原谅?

推荐答案

Substring的方法调用后第一个括号前有空格吗?

Is there a space after the method call to Substring before the first parenthesis?

它出现在第 40 行:

It appears on Line 40:

IF i > 1 AND j > 1 AND (s1_char = SUBSTRING (s2, j - 1, 1))

即确保

select substring(CustomerName, 1, 4) AS CustName from MyTable;

代替:

select substring (CustomerName, 1, 4) AS CustName from MyTable;

相关文章