How can I pass tablename as a parameter in MySQL stored procedure?
my SQL stored procedure is like this....
ALTER PROCEDURE [dbo].[Sp_InsertDataMaster]
@_ImageID int,
@_Stat bit,
@_tablename nvarchar(200)
AS
begin
declare @strTemp nvarchar(max)
set @strTemp = 'Insert into ' + @_tablename + '(ImageID,Status) values ('+ convert(nvarchar(5),@_ImageID) +','+ CONVERT(nvarchar(1),@_Stat) +')'
--print @strTemp
exec(@strTemp)
end
I want this stored procedure in MYSQL.
Software/Hardware used:
Software/Hardware used:
ASKED:
February 14, 2009 8:38 AM
UPDATED:
February 18, 2009 2:17 AM
Answer Wiki:
It would be something <b><i>similar</i></b> to this:
<pre>CREATE PROCEDURE test
( ImageID varchar(10),
Stat varchar(1),
tablename varchar(200))
BEGIN
SET @s = CONCAT('INSERT INTO ',tablename,' (ImageId,Status) values (',ImageID,',',Stat,')')
PREPARE stmt FROM @s;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
END;</pre>
(change data types as needed...)
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
