编程论坛 » MySQL » [求助]mysql5存储过程出错

mihaisheng 发表于 2006-3-6 19:51

[求助]mysql5存储过程出错

create procedure myproc5 (c1 int,c2 varchar(20),c3 varchar(50))<BR>begin<BR>    insert into table1 values ( c1 , c2 , c3 );<BR>end;<BR>帮我看看,哪错了啊???

mihaisheng 发表于 2006-3-7 11:47

[local] ERROR 1064: 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 'insert into table1 values ( c1 , c2 , c3 )' at line 3<BR>[local] ERROR 1064: 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 'end' at line 1

weizy 发表于 2006-8-1 16:04

DELIMITER $$<BR>create procedure myproc5 (c1 int,c2 varchar(20),c3 varchar(50))<BR>begin<BR>    insert into AAA value( c1 , c2 , c3 );<BR>end;$$<BR>DELIMITER ;<BR>

查看完整版本: [求助]mysql5存储过程出错