DBD::mysql:st execute failed: Column count doesn't match value count at row 1 at dbtest.pl line 22
####
#!perl -w
use strict;
use DBI;
my $DS="dbi:mysql:QuizTaker";
my $User="tstanley";
my $File="A_Plus_Core.psv";
open(FH,"$File")||die"Can't open $File: $!\n";
my @Array=;
close FH;
my $DBH=DBI->connect($DS,$User)||die"Can't connect: $DBI::errstr\n";
my $AnswerE="NULL";
foreach my $element(@Array){
my($TN,$Question,$AnswerA,$AnswerB,$AnswerC,$AnswerD,$Correct)=split /\|/,$element;
chomp($Correct);
my $STH=$DBH->prepare_cached(<execute($TN,$Question,$AnswerA,$AnswerB,$AnswerC,$AnswerD,$AnswerE,$Correct);
}
$DBH->disconnect;
####
create table Questions(Test_Number integer(2) NOT NULL,
Question varchar(255) NOT NULL,
Answer_A varchar(255) NOT NULL,
Answer_B varchar(255) NOT NULL,
Answer_C varchar(255),
Answer_D varchar(255),
Answer_E varchar(255),
Correct_Answer varchar(10));