I have a MySQL table named "Amount", which has amounts like 200, 300, 100 etc. But, what I want is, that the amounts should be 200.00, 300.00,100.00. How do I write a query to update the column, so that it adds the ending zeroes? The column is float.
I tried with a regular update query, but it failed and I had to revert the changes (re-upload a backup sql file).
Any suggestions are welcome.