in reply to have a script autmatically create a SQL database

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....

  • Comment on Re: have a script autmatically create a SQL database