DELIMITER //
CREATE PROCEDURE sp_Insert_Total
(IN TotID INT(4),IN newtotal INT(4))
proc_insert:BEGIN
SELECT COUNT(*) FROM DEMO INTO TotID;
SET TotID = LAST_INSERT_ID();
INSERT INTO DEMO (ID, Total) VALUES ('TotID','newtotal');
END proc_insert;
//
DELIMITER ;
CALL sp_Insert_Total ('', '30');
thanks