Results 1 to 2 of 2

Thread: MySQL addition

  1. Jul 15th, 2007, 09:36 PM #1
    k1ll3rdr4g0n
    k1ll3rdr4g0n is offline

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2004
    Posts
    751

    MySQL addition

    Heres a tough one (maybe not so tough?), lets say I have a column called 'hits', and I have 2 rows with hits = 3 (for arguments sake). Is it possible to make MySQL add up the 2 rows to make it return 6?
    Last edited by k1ll3rdr4g0n; Jul 15th, 2007 at 09:42 PM.
    My Projects: [ Instant Messagener Client/Server ] [ VBPictochat ]

    My Sites:
    [ Datanethost ]
    [ Helpdesk ]

    Remember if my post was helpful then Rate This Post.
    Reply With Quote Reply With Quote
  2. Jul 15th, 2007, 09:37 PM #2
    k1ll3rdr4g0n
    k1ll3rdr4g0n is offline

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2004
    Posts
    751

    Re: MySQL addition

    haha I just figure it out:

    SELECT count(column name) FROM table;

    Edit:

    Actually thats not it sorry...hmmm

    Its really SUM(column name)
    Last edited by k1ll3rdr4g0n; Jul 15th, 2007 at 09:44 PM.
    My Projects: [ Instant Messagener Client/Server ] [ VBPictochat ]

    My Sites:
    [ Datanethost ]
    [ Helpdesk ]

    Remember if my post was helpful then Rate This Post.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width