Hello -

I=92m wondering if anyone would have any advice for me on producing a report that would look for changes in a MySQL database table - particularly in 2 or 3 fields.

I have a table of 15,000 or so students and need a report that shows when a particular field has changed and then grab that record. The issue is that the table is completely refreshed each evening. A delete is performed and then the new data is imported from our master database. (MS SQL)

I could duplicate the old table but what is the most efficient way to do a compare? Thanks for any insight.


PLEASE NOTE: My e-mail address has changed to: plarkin@basdschools.org
––
Patrick Larkin
Application Management Group
Information Technology
Bethlehem Area School District
https://www.beth.k12.pa.us

#############################################################
Attend the Lasso Developer Conference 2014!
October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
http://www.lassosoft.com/LDC-newmarket-2014

#############################################################

This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>