CREATE TABLE catalog ( phone_number VARCHAR(10) PRIMARY KEY NOT NULL, name VARCHAR(255), address VARCHAR(255), notes VARCHAR(255) ); CREATE TABLE change_log ( transaction_id INT(10) PRIMARY KEY NOT NULL AUTO INCREMENT, timestamp TIMESTAMP, number_record VARCHAR(255), action VARCHAR(255) ); #### #!/usr/bin/perl use strict; use warnings; use DBI; use DBD::mysql; #this is my config module use DBase::MySQL::Config qw(DB_CUSTOMER_CATALOG DB_USER DB_PW); my $dbh = DBI->connect(DB_CUSTOMER_CATALOG, DB_USER, DB_PW); my $query = "INSERT INTO catalog (phone_number) VALUES ('5555555555'), ('1111111111');"; $dbh->do($query); $dbh->disconnect();