Q:
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.
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.
ASKED:
Feb 14 2009 8:38 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
+1
Click to Vote:
+1
Click to Vote:
- 1
0
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;
(change data types as needed...)
