Excursions into Stored Procedures
February 7th, 2006Today I started messing with stored procedures in MySQL. I had a few bumps in the road, mainly caused by an upgrade from MySQL from 4.x to 5.x. That resolved, I created my first stored procedure.
After a bit of tooling, I made a procedure that will populate a table with an initial dataset of 50,000 records. This took three seconds! All I can say is - wow.
Database admins will likely say this is old hat to them - but I’m not a db admin, but I’m definitely learning.