MySQL in a Nutshell

Name

execute( )

Synopsis

$statement_handle->execute( )

This executes a statement handle that has been processed with the prepare( ) method. There are no arguments to this function.

 . . .
my $dbh = DBI->connect ("$data_source","$user","$pwd")
my $sql_stmnt = "SELECT * FROM books";
my $sth = $dbh->prepare($sql_stmnt);
$sth->execute( );

Although this excerpt will execute the given statement, it will not display the results. To do this, a method like fetchrow_array( ) is needed.