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
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]