in reply to reading txt and update into database table
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!
|
|---|