Simple stored procedure question

[Les Stockton]

Forgive me for asking this. I checked the documentation, but was unclear on some of this, so I decided to go try to create this stored procedure, which does work in SQL Server. I'm wanting to do the same thing in MySQL.

Create Proc MyAddRecord ( @TblName varchar(50), @NewIDVal int OUTPUT ) AS EXECUTE('INSERT INTO [' + @TblName +

'] DEFAULT VALUES') SET @NewIDVal = @@IDENTITY


I tried the following:
CREATE PROCEDURE `testcreate`.`MyAddRecord` (@TblName varchar(50),@NewIDVal int OUTPUT)
BEGIN
EXECUTE('INSERT INTO [' + @TblName + '] DEFAULT VALUES')
SET @NewIDVal = @@IDENTITY
END

That didn't work.
So is this a small incompatibility and a slight syntax change, or is this an entirely different thing?
Can someone tell me what the correct Create Procedure would be?