How to multiply a field in SQL?

Question

SQL

Hello.
I'm trying to make the multiplication of the money field in the SQL query, but it doesn't work. UPDATE didn't help either. But, the request is not executed, it just displays the result like this. The result worked fine, but the database was not updated.
SELECT `money` * 10 FROM `users` WHERE `id`=36454

Answer 1

The UPDATE statement is used to update data in the database.