in reply to Re: Mysql syntax error
in thread Mysql syntax error from DBI
should do the trick.my $sth =$dbh ->prepare("UPDATE products set pname=? and unit=? and qty=? and cost=? WHERE id = ?");
No. It shouldn't.
The SQL syntax is wrong (see meetraz's answer.
In Section
Seekers of Perl Wisdom