Sample Code Code: INSERT INTO names VALUES ('John') How do you use the DBI module to execute the above SQL statement? Assume $dbh is the return value from DBI->connect.
my $statement = $dbh->execute("INSERT INTO names VALUES ('John')");
my $statement = $dbh->run("INSERT INTO names VALUES ('John')");
my $statement = $dbh->prepare("INSERT INTO names VALUES ('John')"); $statement->execute;
my $statement = $dbh->sql("INSERT INTO names VALUES ('John')"); $statement->execute;