Page 1 of 1

mysql Help?

Posted: Wed Feb 03, 2010 1:37 am
by adilmarwat2004
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

Re: mysql Help?

Posted: Wed Feb 03, 2010 1:53 am
by JakeJ
You need to use the UPDATE command.

UPDATE info SET iii = iii * 1.15

Re: mysql Help?

Posted: Wed Feb 03, 2010 3:01 am
by adilmarwat2004
thanks,