Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Stored procedure in mysql

 
Kunal Lakhani
Ranch Hand
Posts: 622
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am a beginner in mysql stored procedure

What is wrong with this mysql stored procedure?



Mysql console gives me following error

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'SELEC
T POLICYNUMBER FROM MEMBERPLACEMENT WHERE INTRODUCERPOLICYNUMBER = b AND PL'
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic