1478 - syntax error at or near "FUNCTION"

[exqmjmz]

在mysql模式下无法通过查询的方式直接创建函数function
以下是我执行的sql，通过从mysql库中复制出来的ddl进行创建

CREATE DEFINER=`halo`@`%` FUNCTION `json_extract_c`(details text, required_field VARCHAR (255)) RETURNS text CHARSET utf8mb4 COLLATE utf8mb4_general_ci
BEGIN
		
		SET details = SUBSTRING_INDEX( details, "{", - 1 );
	
	SET details = SUBSTRING_INDEX( details, "}", 1 );
	RETURN TRIM(
		BOTH '"' 
		FROM
			SUBSTRING_INDEX(
				SUBSTRING_INDEX( SUBSTRING_INDEX( details, CONCAT( '"', SUBSTRING_INDEX( required_field, '$.', - 1 ), '":' ), - 1 ), ',"', 1 ),
				':',
				- 1 
			) 
		);
	
END

[ThinkJ001]

currently CREATE FUNCTION/CREATE PROCEDURE is not supported yet. this feature will support soon. thanks for your feedback.