I am using mysql. which has database name "act" and contains table name "info' contain three fields (i) id (ii) name (iii)salary
Now I want to add 15% salary to the salary field to all the table.
How it is possible, please help?
Adil
mysql Help?
Moderator: General Moderators
Re: mysql Help?
You need to use the UPDATE command.
UPDATE info SET iii = iii * 1.15
UPDATE info SET iii = iii * 1.15
-
adilmarwat2004
- Forum Commoner
- Posts: 44
- Joined: Fri Sep 04, 2009 11:28 pm
Re: mysql Help?
thanks,