Dabbling in Live Databases: MySQL - Page 8

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:

• MySQL Mirror Sites
• Do I Need to License MySQL?
• SQL Reference Page
• DBI Module Documentation
• DBI Frequently Asked Questions
• LinuxPlanet's Setting up a MySQL Based Website