日期:2014-05-16  浏览次数:20631 次

简单存储过程出错
SQL code
DELIMITER $$
create PROCEDURE Ck_sub
BEGIN
insert 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()
------解决方案--------------------
过程名后面要打小括号