Stored Procedure Insert Problem
Posted: Thu Aug 21, 2008 11:29 pm
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
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