interacting with table layouts using DBI

From: Andrew Gaffney (agaffney_at_skylineaero.com)
Date: 03/03/04 

Date: Tue, 02 Mar 2004 17:53:37 -0600
To: beginners <beginners@perl.org>

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. 

-- 
Andrew Gaffney
Network Administrator
Skyline Aeronautics, LLC.
636-357-1548

Relevant Pages

  • Re: interacting with table layouts using DBI
    ... > and modify the layout of database tables in a MySQL DB? ... You might want to look at Class::DBI on CPAN. ...
    (perl.beginners)
  • Re: Getting fax # from Contacts dB
    ... The field names in the Phone Numbers database (which is, in turn, ... placed within the Contacts Entry layout of the Contacts database) are: ... ::Communication Data ... since a unique Customer ID would be all that's needed to look up ...
    (comp.databases.filemaker)
  • Re: Show records based on creator
    ... the creator (name comes from user name in the Prefs). ... It's easy enough to have the startup Script perform a Find using the ... Go To Layout ... Do you really need everyone's To Do records in the same database? ...
    (comp.databases.filemaker)
  • Re: Im new to FMP 7
    ... button to go where you want it to go and set the startup layout (unfer file> ... I've managed to create a database to track faults. ... start with a zero. ... 2)We have two separate divisions, one is LD and the other is MOB. ...
    (comp.databases.filemaker)
  • Re: Show records based on creator
    ... By changing in your response 'Table' by 'File', as the requester specified he was using FileMaker 6, would your solution still be applicable? ... It's easy enough to have the startup Script perform a Find using the ... Go To Layout ... Do you really need everyone's To Do records in the same database? ...
    (comp.databases.filemaker)