Connecting to a database:

use DBI;
$dbh = DBI->connect('DBI:mysql:databasename', 'username', 'password'
	           ) || die "Could not connect to database: $DBI::errstr";
# (insert query examples here...)

i do the Simple query

$dbh->do('CREATE TABLE school_tbl (id INT, val VARCHAR(100))');

with the following values: 
  `LOCATION` char(1) NOT NULL,
  `NAME` varchar(130) NOT NULL,
  `TYPE` varchar(40) DEFAULT NULL,
  `ADRESS` smallint(6) NOT NULL,
  `DESCRIPTION` varchar(30) NOT NULL,


$dbh->do('INSERT INTO school_tbl VALUES(LOCATION, ?)', undef, 'Hello');
$dbh->do('INSERT INTO school_tbl VALUES(NAME, ?)', undef, 'World');
$dbh->do('INSERT INTO school_tbl VALUES(TYPE, ?)', undef, 'Hello');
$dbh->do('INSERT INTO school_tbl VALUES(ADRESS, ?)', undef, 'World');
$dbh->do('INSERT INTO school_tbl VALUES(DESCRIPTION, ?)', undef, 'Hello');

print "Insert the  $c rows\n";

$dbh->disconnect();