RosettaCodeData/Task/Parameterized-SQL-statement/Raku/parameterized-sql-statement.raku

8 lines
254 B
Raku
Raw Permalink Normal View History

2023-07-01 11:58:00 -04:00
use DBIish;
my $db = DBIish.connect('DBI:mysql:mydatabase:host','login','password');
my $update = $db.prepare("UPDATE players SET name = ?, score = ?, active = ? WHERE jerseyNum = ?");
my $rows-affected = $update.execute("Smith, Steve",42,'true',99);