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
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
CREATE TABLE IF NOT EXISTS `dictionary` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`word` varchar(100) NOT NULL,
`mean` varchar(300) NOT NULL,
PRIMARY KEY (`id`)
Now you’ve to add 110000 dummy data to this table. You can dump
some dummy data to the table …[Read more]