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

8 lines
249 B
Perl

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);