July 16, 2014 at 1:11 am
i have a select query in business logic page ,, that query im passing as input parameter for stored procedure in my SQL . its not taking query as in parameter in mysql can any1 please help me
this is what in SQL example ..sqlstmt is a select query(select * from employee)
create procedure [dbo].[Demo]
@sqlstmt nvarchar(1000)
as
declare @qry nvarchar(1000)
set @qry = @sqlstmt
exec sp_executesql @qry
same i need in mysql
July 16, 2014 at 2:16 am
Ever used google before?
http://stackoverflow.com/questions/190776/how-to-have-dynamic-sql-in-mysql-stored-procedure
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2014 at 4:52 am
Moved to. MySQL forums
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy