mysql Help?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
adilmarwat2004
Forum Commoner
Posts: 44
Joined: Fri Sep 04, 2009 11:28 pm

mysql Help?

Post 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
JakeJ
Forum Regular
Posts: 675
Joined: Thu Dec 10, 2009 6:27 pm

Re: mysql Help?

Post by JakeJ »

You need to use the UPDATE command.

UPDATE info SET iii = iii * 1.15
adilmarwat2004
Forum Commoner
Posts: 44
Joined: Fri Sep 04, 2009 11:28 pm

Re: mysql Help?

Post by adilmarwat2004 »

thanks,
Post Reply