Insert statement with DBI connection : ODBC « Database « Perl

Home
Perl
1.Array
2.CGI
3.Class
4.Data Type
5.Database
6.File
7.GUI
8.Hash
9.Language Basics
10.Network
11.Regular Expression
12.Report
13.Statement
14.String
15.Subroutine
16.System Functions
17.Win32
18.XML
Perl » Database » ODBC 
Insert statement with DBI connection
   

#!c:/perl/bin

use DBI;

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

$sqlstatement="INSERT INTO emp (firstname, lastname, address)VALUES ('A', 'T', 'I')";

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

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

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

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

   
    
    
  
Related examples in the same category
1.DBI ODBC
2.Delete a record from the database
3.Delete statement and DBI ODBC connection
4.Program to insert a new record into the database
5.Query a database and display the contents in a table
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.