初学存储过程,写了一个最简单的存储过程但是出错不知道问题出在哪delimiter//
create procedure insert_stu(in name varchar,in id int)
insert into student(name,stuclassid) values(name,id);
end//但是有问题,帮忙看看
create procedure insert_stu(in name varchar,in id int)
insert into student(name,stuclassid) values(name,id);
end//但是有问题,帮忙看看
create procedure insert_stu(in name varchar,in id int)
insert into student(name,stuclassid) values(name,id);
end;//
最后记得改回终止符 delimiter//
create procedure insert_stu(in name varchar,in id int)
insert into student(name,stuclassid) values(name,id);
end;//delimiter ;
ERROR 1064 (42000): 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 'in id
int)
begin
insert into student(name,stuclassid) values(name,id);
end' at line 1
create procedure insert_stu(in name varchar,in id int)
begin
insert into student(name,stuclassid) values(name,id);
end;
$$delimiter ;漏掉了BEGIN
create procedure insert_stu(in name VARCHAR(100),in id int)
BEGIN
SELECT 'OK';
END;
$$delimiter ;
我建立了一个跟你差不多的 是可以执行 的
create procedure insert_stu(in name varchar(100),in id int)
begin
insert into student(name,stuclassid) values(name,id);
end;
$$delimiter ;
insert into student(name,stuclassid) values(name,id);改成如上。
insert into student(name,stuclassid) values(name,id)
that'ok 楼主头像是三国杀陆逊?
delimiter $$
create procedure insert_stu()
begin
insert into student(name,stuclassid) values(111,1);
end;
$$
insert into student(name,stuclassid) values(name,id)
就可以啦 楼主的语句2个问题 一个是只有end 没有begin 还有个就是varchar没有长度
MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html