Hello,
Installing DBI-1.51 - 'make test' returns results that seem strange. Any
tests that 'use Storable' attempt to load an old version installed under
Perl 5.6. A newer version of Storable is installed under Perl 5.8. The
new version is in @INC prior to the old version. Since I'm installing
DBI
$db is your database name.
So how do you connect and talk to MySQL without an existing database
with DBI?
A
> -Original Message-
> From: Andrew Brosnan [mailto:andrew@;broscom.com]
> Sent: Friday, October 18, 2002 1:54 PM
> To: Hardy Merrill
> Cc: Post; [EMAIL PROTECTED]
>
On 10/18/02 at 2:43 PM, [EMAIL PROTECTED] (Jeff Zucker) wrote:
> Andrew Brosnan wrote:
>
> Did you try it? This works for me (notice there's no database
specified
> in the connection):
>
> my $dbh = DBI->connect("dbi:mysql:");
> $dbh->do(&qu
sume you misunderstood my question.
Just the way you might create a table or make a query by executing some
SQL via DBI, I want to be able to create a new database from my perl
script via DBI.
Thanks Hardy!
Andrew
> --
> Hardy Merrill
> Senior Software Engineer
> Red Hat, Inc.
>
&g
On 10/18/02 at 2:10 PM, [EMAIL PROTECTED] (Jeff Zucker) wrote:
> Andrew Brosnan wrote:
>
> > On 10/18/02 at 4:26 PM, [EMAIL PROTECTED] (Hardy Merrill) wrote:
> >
> >>What database are you using?
> >>
> > Not sure why it would matter, but MySQL.
>
;y')");
>
> $dbh->do("insert into db (host, db, user, select_priv, insert_priv,
> update_priv, delete_priv, create_priv, drop_priv, grant_priv,
> references_priv, index_priv, alter_priv) values
> ('$ip','$database_name','$user',&
Hello List,
I'm looking to *create* a database with DBI. I couldn't glean this from
the docs. Seems like you first need to connect to a datasource(database)
to issue statements.
Is there a way to 'CREATE DATABASE DatabaseName;' with DBI?
Thanks,
Andrew