Page 1 of 1

Stored Procedure Insert Problem

Posted: Thu Aug 21, 2008 11:29 pm
by chelflores
My stored procedure doesnt insert new record, when i try the query only, it works

CREATE PROCEDURE insertguest(in_gname VARCHAR(30))
BEGIN
DECLARE gid INT;
SELECT MAX(GuestID) as id FROM guest;
SET gid = id;
SET gid = gid + 1;
INSERT INTO guest(GuestID,Gname) VALUES(gid,in_gname);

END