1064 - You have an error in your SQL syntax； check the manual that corresponds to your MySQL server

最新推荐文章于 2024-03-18 17:21:31 发布

原创

最新推荐文章于 2024-03-18 17:21:31 发布 · 2.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #mysql #数据库

问题描述

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DELIMITER’ at line 1


DROP FUNCTION
IF
	EXISTS `ExtractNumber`;

DELIMITER $$
CREATE FUNCTION`ExtractNumber`(in_string VARCHAR (50)) 
RETURNS INT 
NO SQL
	BEGIN
	DECLARE
		ctrNumber VARCHAR (50);
	DECLARE
		finNumber VARCHAR (50</