You may find Databases made easy helps get you up to speed enough with database management using Perl to figure this stuff out.

When you have some code that you need some help with come back and show us where the problems are. When you show you've put some effort in yourself you'll find the monks are very forthcoming with help, but we won't generally do your homework for you.

Config::INI or Config::Tiny can read (and write) this type of files easily and transform the contents into a Perl data-structure.

Such data-structure can then be translated into an SQL statement very easily which DBI will use to update your database.

You've provided no indication of your level of Perl expertise or the context of the project you're working on. Accordingly, I'll assume the lowest common denominators for both: minimal Perl knowledge and a small (personal/hobby/learning) project.

Read "perlintro: Perl introduction for beginners". Each section is fairly basic but also provides links to more detailed information and advanced topics: follow these as required.

For "I have to read this file", you'll want to focus on the "Files and I/O" section in that document.

For your database work, look at DBI. This isn't a core (builtin) module so you'll need to install it: you can use the builtin cpan utility for that task.

You'll also need a database driver module (and you'll need to install that as well). These modules have names like DBD::xxx, where xxx will be something like Oracle. You provided no information about the database system you're using; search CPAN for an appropriate "DBD:: module".

At some later point, having done all this, you may require further assistance. To get the best and quickest responses, follow the guidelines in "How do I post a question effectively?".

Please show the code you have tried, and why it doesn't work.

Please disclose if this is a homework assignment.

Look into SQL placeholders. You want to be doing something like:

#!/usr/bin/env/perl
use strict;
use warnings;
use DBI;
use File::Slurp::Tiny 'read_file';

# pseudo code, obvi

$dbh = get_database_handle_using_DBI()

make_SQL_Statement_with_placeholders()

read_conf_file_Using_File::Slurp::Tiny()

parse_conf_file_and_put_data_into_a_hash()

foreach (table_you_got_from_the_file) {
  do_SQL_statement_with_the_hash_data()
}

# Don't forget to use strict and warnings, and check all your return v
+alues!
[download]

what is best approach to do this.

what DBMS. is this homework.