Comersus Version: 603
Database type: Other
Frequency: Permanent issue
I want to update my prices, and there are thousands! So I tried:-
UPDATE products SET price=17.99
But it didn't work.
I found online that float numbers are not stored exactly as they seem.
Would it affect anything if the price was changed from float to decimal?
I can't experiment, as I am getting orders in all the time.