Is there an easy way with DBI (or anything other modules) to retrieve and modify the layout of database tables in a MySQL DB? I need to write a program to add 2 fields to ~40 tables with an identical layout. The tables are named "m"mmyy where "m" is an actual 'm', mm is a 2 digit month, and yyyy is a 4 digit year. If the table doesn't exist, I want to create it with the same layout as all the rest. I can write a program that does this the hard way, but before I started, I wanted to know if there was an easier way.
To add/modify my query: Is there a module in existance that can act as a wrapper for table structures in a MySQL (or any other) DB? I'm thinking about writing a module that uses a tied hash (which will be a hash of hash references corresponding to different properties of each field). If one doesn't exist, I'd like to atleast try my hand at creating something like this for easily adding and modifying tables via DBI.
-- Andrew Gaffney Network Administrator Skyline Aeronautics, LLC. 636-357-1548
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
