Archive for the Database functions Category

Audit of transactions using MySQL aggregate queries

Shows how to perform various audit tests using MySQL aggregate functions to obtain totals, minima, maxima, etc. Also illustrates the “where” clause which can further isolate or identify the population to be tested.

|