将包含mysql函数的mysql查询传递给PHP mysql_query

DELIMITER $$
DROP FUNCTION IF EXISTS `GetNextID` $$
CREATE FUNCTION `GetNextID`() RETURNS INT DETERMINISTIC
BEGIN
DECLARE NextID INT;
SELECT MAX(articleID) + 5 INTO NextID FROM table_article;
RETURN NextID;
END$$
DELIMITER ;

INSERT INTO table_article ( articleID, articleAlias ) VALUES ( GetNextID(), \'TEST\' );

DELIMITER

mysql

phpMyAdmin

DROP FUNCTION IF EXISTS `GetNextID`

CREATE FUNCTION `GetNextID`() RETURNS INT DETERMINISTIC
BEGIN
DECLARE NextID INT;
SELECT MAX(articleID) + 5 INTO NextID FROM table_article;
RETURN NextID;
END

INSERT INTO table_article ( articleID, articleAlias ) VALUES ( GetNextID(), \'TEST\' )