Delete statement and DBI ODBC connection : ODBC « Database « Perl






  1. Perl
  2. Database
  3. ODBC

Delete statement and DBI ODBC connection

   

#!C:/perl/bin

use DBI;

$dbhandle = DBI->connect("dbi:ODBC:address");

$sqlstatement="DELETE * FROM emp WHERE address='I'";

print "Content-type: text/html \n\n";

$statementhandle = $dbhandle->prepare($sqlstatement);

$statementhandle->execute || die "<br><br>Could not execute SQL statement ... <br>";
print "<br><br>Executed ...<br>";

$dbhandleandle->disconnect();
$statementhandle->finish();








Related examples in the same category

1.DBI ODBC
2.Delete a record from the database
3.Insert statement with DBI connection
4.Program to insert a new record into the database
5.Query a database and display the contents in a table