开发环境是xampp安装包中的mysql php apache用phpmyadmin创建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 '' at line 3 ”
代码如下:CREATE PROCEDURE ptest()
BEGIN
select * from tt;
END;后来在网上找到一片文章(http://www.cnblogs.com/hsqzzzl/archive/2008/02/21/1076646.html),按照里面的例子CREATE PROCEDURE ptest()
BEGIN
SELECT 'Hello Word!' AS F;
END //还是这个错误,请问我改怎么改代码。
代码如下:CREATE PROCEDURE ptest()
BEGIN
select * from tt;
END;后来在网上找到一片文章(http://www.cnblogs.com/hsqzzzl/archive/2008/02/21/1076646.html),按照里面的例子CREATE PROCEDURE ptest()
BEGIN
SELECT 'Hello Word!' AS F;
END //还是这个错误,请问我改怎么改代码。
DELIMITER // <--加上这句试试,更改语句结束标志。
CREATE PROCEDURE ptest()
BEGIN
SELECT 'Hello Word!' AS F;
END
//
BEGIN
select * from tt;
END;
//delimiter ;CSDN MySQL http://forum.csdn.net/SList/MySQLPostgresql
CREATE FUNCTION hello( s varchar(30))
RETURNS VARCHAR(255)
BEGIN
DECLARE str varchar(255) default 'hello ';
SET str = concat(str,s);
RETURN str;
END
;