Question

What is the use of stored procedures in mysql than query?

Answer 1

It's easier to code stored procedures than to build a query through a GUI. Use of stored procedures can reduce network traffic between clients and servers, because the commands are executed as a single batch of code