Re: Simple stored procedure question

[Les Stockton]

Got it to work, as follows:

CREATE PROCEDURE `testcreate`.`MyAddRecord`(IN TblName varchar(50),OUT NewIDVal int)
BEGIN
SET @stmt := CONCAT('INSERT INTO ', TblName, ' () VALUES()');
PREPARE stmt1 FROM @stmt;
EXECUTE stmt1;
SET NewIDVal := LAST_INSERT_ID();
END