• Post Reply Bookmark Topic Watch Topic
  • New Topic

MYSQL Creating a stored procedure that counts book written by author.  RSS feed

 
Josef Lundström
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello!

I am trying to create a stored procedure in MYSQL, which I intend to count books in a table that is written by a certain author:



@bookCounter is null... How can I modify the stored procedure to get the expected result?
Thanks!
 
Rob Spoor
Sheriff
Posts: 21092
85
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
bookCounter is a local variable to the stored procedure. Try turning it into an OUT procedure parameter.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!