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.
Yes it matters. This works for me using MySQL:
my $existing_db = $your_old_db_here;
my $new_db = $your_new_db_here;
my $dbh = DBI->connect("dbi:mysql:database=$existing_db" ...);
$dbh->do("CREATE DATABASE $new_db");
$dbh->do("USE $newdb");
# commands to create and query tables in $new_db
--
Jeff
