读书人

简单存储过程出错,该怎么解决

发布时间: 2012-04-13 13:50:24 作者: rapoo

简单存储过程出错

SQL code
DELIMITER $$create PROCEDURE Ck_subBEGINinsert into ck select * from ckqd;delete from ckqd;end$$


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 'BEGIN
insert into ck select * from ckqd;
delete from ckqd;
end' at line 2老出错怎么回事,该怎么写

[解决办法]
create PROCEDURE Ck_sub()
[解决办法]
过程名后面要打小括号

读书人网 >Mysql

热点推荐