Need someone to do the following:
Read these values from a file:
Example (we can remove the dollars sign)
The above values will be in a text file or a excel (whatever you choose).
Then we need an sql statement that reads the above values from the file. Examples:
update products set products_price="1.00" where products_model="1234";
Why do we need done this way: Becasue we need to update our prices on regular bases and this is the best way we can think of.
We need this done fairly quick.