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