首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > Mysql >

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

2012-04-13 
简单存储过程出错SQL codeDELIMITER $$create PROCEDURE Ck_subBEGINinsert into ck select * from ckqdd

简单存储过程出错

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()
[解决办法]
过程名后面要打小括号

热点排行