简单存储过程出错
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()
------解决方案--------------------过程名后面要打小括号