Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add percentage to values in column

Status
Not open for further replies.
dessie1981

dessie1981

Programmer
May 9, 2006
116
GB
Hi Everyone,

I have a price column in my Database and need to add 20% on to
each figure in the price column, is this possibe with mysql?

Thanks
Des
 
Sort by date Sort by votes
Its ok everyone just figured out how to use maths operators with mysql.!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
476
spamjim
spamjim
penguinspeaks
  • Locked
  • Question
Update column based on input from another column 3
Replies
6
Views
415
penguinspeaks
penguinspeaks
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
407
Chris Miller
Chris Miller
jawadfrhad
  • Locked
  • Question
how make row to column
Replies
4
Views
168
jawadfrhad
jawadfrhad
EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
518
EdLentz
EdLentz

Part and Inventory Search

Sponsor

Back
Top