home.social

#sqlmode — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #sqlmode, aggregated by home.social.

  1. PrecisionSQL @[email protected] ·

    How to Avoid GROUP BY Returning Random Rows

    Non-aggregated columns can return garbage.

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

    youtube.com/watch?v=mKt4TxGkaAU

    #mysql #groupby #bug #howto #sqlmode #analytics
  2. PrecisionSQL @[email protected] ·

    How to Stop Silent Truncation With strict SQL mode

    MySQL can clip data without errors.

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

    youtube.com/watch?v=NF4CZz_TIWo

    #mysql #sqlmode #truncation #howto #dataintegrity #production
  3. PrecisionSQL @[email protected] ·

    How to Stop Silent Truncation With strict SQL mode

    MySQL can clip data without errors.

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

    youtube.com/watch?v=NF4CZz_TIWo

    #mysql #sqlmode #truncation #howto #dataintegrity #production
  4. PrecisionSQL @[email protected] ·

    How to Stop Silent Truncation With strict SQL mode

    MySQL can clip data without errors.

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

    youtube.com/watch?v=NF4CZz_TIWo

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