SQL 错误 1630:函数 SUBSTRING 不存在.. 是吧? [英] SQL Error 1630: Function SUBSTRING does not exist.. huh?

问题描述

没错.所以我在 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;

这篇关于SQL 错误 1630:函数 SUBSTRING 不存在.. 是吧?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！