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
must not fail, thus we don't
# catch errors.
$dbh->do("CREATE TABLE foo (id INTEGER, name VARCHAR(20)");
...
Kirk
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of Ken
>Hilliard
>Sent: Wednesday, January 08, 2003
Does anyone know how to create the initial database and tables
programmatically via DBI under MYSQL. I've been creating the application
database and required tables using the provided MYSQL utilities and then
using the Perl DBI to insert/update/delete records. I know that MYSQL's
command line utili
