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("CREATE DATABASE $new_db");
> $dbh->do("USE $new_db");
> # commands to create and query tables in $new_db
YOU'RE THE MAN!!! Thanks!
On 10/18/02 at 2:58 PM, [EMAIL PROTECTED] (Jeff Zucker) wrote:
> CREATE DATABASE is not part of either SQL92 or SQL99. They have a
> CREATE SCHEMA syntax. But, AFAIK, most implementations do have a
> CREATE DATABASE command anyway.
>
I was afraid of that when I didn't see it in the book.
btw, can you point me to where can I find the docs for SQL92 or SQL99?
Thanks again Jeff. (and all)
Andrew
