in reply to Re^6: mysql update table how to
in thread mysql update table how to
Why take the risk, it's easy enough to avoid
my $sql= 'UPDATE EmployerJobs SET Disabled = ? WHERE USERID = ?'; my $dbh = DB::connect (); my $count = $dbh->do($sql,undef,$DISABLED,$userid); $dbh->disconnect (); printf "%d records updated\n",$count;
also be aware that by not using the ->update_record() method in package DB::TableInfo you could be missing important audit logging or database consistency/integrity checks.
poj
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^8: mysql update table how to
by VC (Novice) on Apr 07, 2019 at 22:48 UTC |
In Section
Seekers of Perl Wisdom