MySQL stored procedures are programs that are stored and can be executed on the MySQL server. You can call stored procedure from any application over a distributed network. Stored procedures provide a means of interacting in a prescribed way with the database without placing any additional traffic on the network. Here I’m describing a stored procedure that I used to create some sample data.
To learn more about stored procedure checkout this link.
Suppose you may need to create a large number of dataset for a table and your table structure looks like this… [Read more...]