Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MYSQL Expand / Collapse
Author
Message
Posted Wednesday, July 16, 2014 1:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:24 AM
Points: 1, Visits: 12
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
Post #1592930
Posted Wednesday, July 16, 2014 2:16 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:45 AM
Points: 13,552, Visits: 10,428
Ever used google before?

http://stackoverflow.com/questions/190776/how-to-have-dynamic-sql-in-mysql-stored-procedure




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1592949
Posted Wednesday, July 16, 2014 4:52 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:01 AM
Points: 33,157, Visits: 15,294
Moved to. MySQL forums






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1592984
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse