Post #1089170

Today's challenge: Recalculating the aggregate figures for 6+ years worth of data and then comparing them to check that nothing has changed. Thankfully MariaDB makes it easy to copy a table (CREATE t1_copy AS (SELECT * FROM t1)) and then compare using EXCEPT. Will write this up as a blog post in the coming weeks. #sql #php #MariaDB