Re: Simple stored procedure question

[Les Stockton]

What about this:

CREATE PROCEDURE `testcreate`.`MyAddRecord` (IN TblName varchar(50),OUT NewIDVal int)
BEGIN
EXECUTE(CONCAT('INSERT INTO [', TblName ,'] DEFAULT VALUES'));
SET NewIDVal = @@IDENTITY;
END

If I use the CONCAT, do I still have to do a prepare? And If so, is it like:

PREPARE stmt1 FROM CONCAT('INSERT INTO [', TblName ,'] DEFAULT VALUES')

Can I do it that way?

or does it have to be:

PREPARE stmt1 FROM 'INSERT INTO [?] DEFAULT'
SET @a = TblName

EXECUTE stmt1 USING @a

And do I have to declare @a and stmt1?



Edited 1 time(s). Last edit at 01/12/2006 03:38PM by Les Stockton.