#!/usr/local/bin/perl
use DBI;
my $db_name = "database name";
my $db_uid = "userid";
my $db_pwd = "password";
my $dsn = "DBI:mysql:$db_name";
my $dbh = DBI->connect($dsn,$db_uid,$db_pwd);
...
Basic method. There are a others
$query = "INSERT INTO TableName VALUES('$item1', .. same number of (quoted) items as columns in your table ..')";
$dbh->do($query);
...
$dbh->disconnect(); # when you are done using the database
exit;
