The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I need some sort of program or batch file written that will convert a flat text file into a SQL query. The program will need to run on my Windows PC. The text file looks like this:
and I need the SQL query to then look like this:
update products set products_quantity=7 where products_model='AAM0180C';
update products set products_quantity=32 where products_model='AAM0181';
update products set products_quantity=6 where products_model='AAM0201C';
update products set products_quantity=24 where products_model='AAM0202';
update products set products_quantity=9 where products_model='AAM0203C';
update products set products_quantity=12 where products_model='AAM0204';
Sign in or Register to see more