Thanks, Kirk. I wrote a quick script and it worked fine.
-Original Message-
From: Kirk [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 4:52 PM
To: Ken Hilliard
Cc: [EMAIL PROTECTED]
Subject: RE: [Perl-unix-users] Creating a MYSQL database
programmatically via DBI
perldoc
perldoc DBD::mysql
and from the above result in the 'admin' section:
...
$rc = $drh->func('createdb', $database, $host, $user, $password, 'admin');
...
and for table creation and in the 'example' section:
...
# Create a new table 'foo'. This must not fail, thus we don't
# catch errors.
$dbh->do("