how to add same columns in table in mysql? : I have one table named **tripdetails**:
**table structure:**

**trip no**    **invoice no**   **total balance**
111              1               500
111              2               800
 
      i want to add these two invoices **total balance**...means 500+800=1300....
                    