Simple Inserts : insert « Database « Perl






  1. Perl
  2. Database
  3. insert

Simple Inserts

   

#!\usr\bin\perl
use warnings;
use strict;
use DBI;
my ($dbh, $rows);
$dbh=DBI->connect('dbi:mysql:test','root','password') || die "Error opening database: $DBI::errstr\n";
$rows=$dbh->do("INSERT INTO checkin (firstname, lastname, destination)VALUES ('John', 'Smith', 'Glasgow')")|| die "Couldn't insert record : $DBI::errstr";
print "$rows row(s) added to checkin\n";
$dbh->disconnect || die "Failed to disconnect\n";








Related examples in the same category

1.Using Multiple Placeholders
2.Using Placeholders to Insert Multiple Records
3.do() method prepares and executes nonselect, nonrepeating statements in one step.