my $sth = $dbh->prepare( "CREATE TABLE IF NOT EXISTS admin ( id int auto_increment not null, username VARCHAR(25) DEFAULT 'admin' NOT NULL, password VARCHAR(36) DEFAULT '1a1dc91c907325c69271ddf0c944bc72' NOT NULL, primary key (id) )"); $sth->execute(); if ($sth->errstr) { print $sth->errstr; } else { print "Admin table was setup"; }