Problem with prepare statement, MySQL, and PERL,

[Akino877]

Hello,

I have a small Perl program :

#!/usr/bin/perl -w
use DBI;
use Mysql;
$host = "";
$database = "";
$user = "root";
$password = "a1b2c3";
$db = Mysql->connect ($host, $database, $user, $password) ||
         die "Cannot connect to MySQL database!\n";
$create = $db->prepare ("CREATE TABLE people (
                                     first varchar (32) not null,
                                     last varchar (32) not null ) " );
$create->execute() || die "Cannot create people file!\n";
 

This program can connect to MySQL fine but has an error on the prepare
statement. The error is as follows :

Mysql::prepare: Not defined in Mysql and not autoloadable (last try prepare) at
builddb.pl line 14.
 

I appreciate any help you can provide.

Akino.

[Atli]

Hi Akino. Welcome to TSDN!

I think this problem has more to do with Perl than MySQL, so you may have better luck over in the Perl Forums. I will move this thread over there for you.