Hello Monks, While trying to figure out how DBI works for various things, I've attempted a simple call to delete all rows from a mysql table. I get no errors, but the rows aren't deleted either. What is it that I'm not understanding about DBI's usage?

my $dsn = "DBI:mysql:database=$db1;host=$host;port=$port";
my $dbh = DBI->connect($dsn, $user, $pw,
                    { RaiseError => 1, AutoCommit => 0 });
                    
# delete records from table rtemp
my $sql = "delete from database.table";
my $sth = $dbh->prepare($sql);
my $sth1 = $dbh->do($sql);
[download]