How to Avoid GROUP BY Returning Random Rows

Non-aggregated columns can return garbage.

#mysql #groupby #bug #howto #sqlmode #analytics

https://www.youtube.com/watch?v=mKt4TxGkaAU

How to Stop Silent Truncation With strict SQL mode

MySQL can clip data without errors.

#mysql #sqlmode #truncation #howto #dataintegrity #production

https://www.youtube.com/watch?v=NF4CZz_TIWo