Re: SQL Query

Try removing the print after the die and adding a check after the execute as well. Use the errstr attached to your db connection too. eg:

my $sql = qq| create table colors (
               color varchar(60) default NULL
            ) type=MyISAM;
      |;
my $sth = $dbh->prepare($sql) or die "error." . $dbh->errstr;
$sth->execute() or die "error." . $dbh->errstr;
[download]

What does type=MyISAM do for you?

Comment on Re: SQL Query Download Code

Replies are listed 'Best First'.
(jeffa) 2Re: SQL Query by jeffa (Bishop) on Jan 11, 2002 at 20:24 UTC
You can read all about it at the online mysql documentation: MySQL Table Types. jeffa L-LL-L--L-LL-L--L-LL-L-- -R--R-RR-R--R-RR-R--R-RR F--F--F--F--F--F--F--F-- (the triplet paradiddle)	[reply]