RosettaCodeData/Task/Parametrized-SQL-statement/Perl/parametrized-sql-statement.pl

8 lines
249 B
Perl
Raw Permalink Normal View History

2013-04-10 23:57:08 -07:00
use DBI;
my $db = DBI->connect('DBI:mysql:mydatabase:host','login','password');
$statment = $db->prepare("UPDATE players SET name = ?, score = ?, active = ? WHERE jerseyNum = ?");
$rows_affected = $statment->execute("Smith, Steve",42,'true',99);