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

WQY_data_analyst

于 2022-05-06 21:08:22 发布

阅读量2k

点赞数

文章标签： sql mysql 数据库

本文链接：https://blog.youkuaiyun.com/WQY_python/article/details/124618731

版权

问题描述

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 (