MYSQL

• chanacc08

  Valued Member

  Points: 69

  More actions

  July 16, 2014 at 1:11 am

  #296453

  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

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  July 16, 2014 at 2:16 am

  #1729755

  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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  July 16, 2014 at 4:52 am

  #1729783

  Moved to. MySQL forums