home.social
Sign in Create account

#orderby — Public Fediverse posts

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

  1. PrecisionSQL @[email protected] ·

    How to Avoid MySQL Skipping Indexes With ORDER BY

    Sorting on a different column can kill index usage.

    #mysql #orderby #index #howto #performance #schema

    youtube.com/watch?v=INO1H3JEyCc

    #mysql #orderby #index #howto #performance #schema
  2. PrecisionSQL @[email protected] ·

    How to Fix LIMIT Without ORDER BY Chaos

    LIMIT without order returns random rows.

    #mysql #limit #orderby #howto #bug #consistency

    youtube.com/watch?v=PO4yWy4U5pU

    #mysql #limit #orderby #howto #bug #consistency
  3. PrecisionSQL @[email protected] ·

    ORDER BY NULLs Go WHERE?!

    ORDER BY with NULLs creates chaos! NULLs can go first or last depending on database. This breaks sorting logic! Watch!

    #sql #sqltricks #database #sqltutorial #orderby #nullhandling #sqlquiz #codingchallenge #sqlshorts #sqlbugs #sorting #sqlwtf

    youtube.com/watch?v=TvSwjgh3tw4

    #sql #sqltricks #database #sqltutorial #orderby #nullhandling
  4. PrecisionSQL @[email protected] ·

    SQL Injection In ORDER BY Drops Your Table?!

    SECURITY NIGHTMARE! Everyone secures WHERE clause but ORDER BY is VULNERABLE! User input in ORDER BY can DROP TABLES! Even prepared statements won't save you! Watch this attack!

    #sql #sqlinjection #security #orderby #droptable #sqlvulnerability #sqlfails #productionbug #sqlshorts #databasedisaster #sqlwtf #injectionattack

    youtube.com/watch?v=QeSaSAX24sQ

    #sql #sqlinjection #security #orderby #droptable #sqlvulnerability