I'm trying to teach myself PERL DBI/MySQL and I'm am having trouble
getting this short script to work. I'm running this on RedHat 5.2. I
guess this is not the proper method for inserting a record from and
array into a MySQL table via DBI. Can someone please let me know how I
can fix this script.
my $db = DBI->connect("DBI:mysql:test","root","whiskey");
my @quote = (NULL,'Lakebluff','IL','Milwaukee','WI',485.00,57.2,1043,'48
my $sth = "INSERT INTO oldqts VALUES @quote"
my $oldqts_input = $db->prepare($sth);