need mysql to add debit and credit values separately

[tanveerhabib]

suppose I have a table having these columns

ID
Asset
Debit
Credit

and i need to add debit and credit separately like if asset has debit values 100+200+300 and credit have values -100-200-300 both of them must have total debit = =300 and credit = -300
what will be mysql command to enter
regards

 

[vacunita]

If I understand correctly, something like the following should get you close:

SELECT asset, CONCAT("-",SUM(credit)) AS credit, SUM(debit) AS debit FROM assets GROUP BY asset

With that said, since this is an entirely MYSQL-based question, it would be better posted in: forum436. Nothing to do with PHP really.
----------------------------------
Phil AKA Vacunita
----------------------------------
OS-ception: Running Linux on a Virtual Machine in Windows which itself is running in a Virtual Machine on Mac OSx.

Web & Tech