You might want to invest in Programming the Perl DBI by Descartes and Bunce - you can get it quickly and cheaply from Bookpool.com. I suggest you look at Chapter 3, starting around page 75. This section covers creating tables. Otherwise you might want to read the Perl DBI documentation.

Concerning creation of the database, you might have to interact with something like sqlplus in Oracle or mysqladmin in MySQL to actually create the database - I'm not aware of a create_database utility that can be accessed in DBI. You can create tables in the databse once you have created the database though.

MadraghRua
yet another biologist hacking perl....

In reply to Re: have a script autmatically create a SQL database by MadraghRua
in thread have a script autmatically create a SQL database by lwilliams

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.