Problem - Error: No database selected!

[Akino877]

Hello,

I have a simple Perl program that connects to MySQL and creates a table of
first names and last names. The code is as follows :

#!/usr/bin/perl -w
use DBI;
use Mysql;
use DBD::mysql;
 
$dbname = '';
$dbhost   = 'localhost';
$dbuser   = 'root';
$dbpass  = '';
 
$dbh = DBI->connect("DBI:mysql:dbname=$dbname:$dbhost", $dbuser,           
                                  $dbpass || die "Error: $DBI::errstr!\n";
$create = $dbh->prepare("CREATE TABLE people ( first varchar (32) not null,
                                                                            last varchar (32) not null )
                                     ");
$create->execute() || die "Error: $DBI::errstr!\n";
 

When I ran this program, I got the following error messages :
(line 16 is the execute statement)

DBD::mysql::st execute failed: No database selected at mkdb.pl line 16
Error: No database selected!

Are these errors caused by $dbname being empty? Do I need to assign a name to $dbname? Does the name of the database already exist somewhere or do I need to come up with this name?

Your help is much appreciated.

Akino.

[eWish]

I would say the problem is because a database name was not specified. Yes, you will need to have a vlaue for $dbname. And a value for $dbpass as well.

When making table names it is good pratice to not use reserved words. I know that you have not at this point, just wanted to let you know.

--Kevin