Conclusion
Perl, as a vehicle for sending SQL statements to a database
and retrieving the results, relies on a database-independent
programming interface thanks to the DBI module. This means
you can rely on essentially the same scripts to query
an MS Access database or a MySQL database. What varies
between databases is working with the beasts themselves
-- that is, setting up the database applications and the
databases themselves. Most of this article has focused
on setting up MySQL and understanding its various management
complexities. Once prepped and ready, sending queries
its way is exactly the same as sending queries to the MS
Access database seen in last month's installment.
Additional Resources: