Hello every1, i need some help..
I have a table member with atributes:
no int primary key,
name varchar(255)
create procedure insert_table3(in last int,in name varchar(255))
begin
set autocommit=0;
set @x=0;
lock table member as m1 write;
start transaction;
repeat
insert into member values(@x+1,name);
set @x=@x+1;
until @x > last
end repeat;
if @x=last then
commit;
elseif @x<=last then
rollback;
end if;
end //
The error I get is :
ERROR 1314 (0A000): LOCK is not allowed in stored procedures