-
updating a table - cannot multiply a value
Hello,
I can manage to add a value to a salary, for example:
update myemployees_JS_1910 set salary = salary + 1000 where title = 'Financial Controller';
but I cannot manage to update a salary by a 20% increase, for example:
update myemployees_JS_1910 set salary = salary * 1.2 where title = 'Financial Controller';
The command is executed, but the salary value does not change.
What am I doing wrong?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|