Page 1 of 1

consistency check

Posted: Tue Jul 14, 2009 9:46 pm
by jaime
i have talk about this in the past, but now im tring to implement it.
i need to do this check:
if sum(Debit account) is diferent of sum(loans)+sum(bookeping) echo "error"

im not sure if it would be a mysqldb procedure scenario or not. (maybe a sh script + cron ? )

have anyone done something similar before?
can help with the script/sql ?

thanks in advance,