I am new to scripting. I want to automate things.
I get file named as NY.csv, CA.csv,FL.csv in folder /apps/data. Now these NY,CA and FL have existing data in two tables.
1. I want to retrieve the name NY first from the filename
run 2 queries:
delete * from TABLENAME1 where state='retrieved name from file i.e.(NY)';
delete * from TABLENAME2 where state='NY';
and load the new NY.csv via crontab ( i already have the crontab setup done) . then do the same for CA and then for FL.