Re: Please help debug mysql insert query

[Peter Brawley]

Insert and Update don't combine, they're separate commands, and SUM() aggregates across rows ... I think you mean something like ...

[code[
insert into it.debt
set debt_id0,debt_total=2500, debt_payment=150, debt_payment_date=now();
update it_debt
set total paid=total_paid+150, debt_total_remaining=debt_remaining-150
where debt_id=0;
[/code]