home.social

#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 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
  3. 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
  4. PrecisionSQL @[email protected] ·

    How to Prevent ORDER BY in Subqueries Being Ignored

    MySQL ignores ORDER BY inside subqueries without LIMIT.

    #mysql #orderby #subquery #howto #bug #sql

    youtube.com/watch?v=gqnEYUtf4Pk

    #mysql #orderby #subquery #howto #bug #sql
  5. PrecisionSQL @[email protected] ·

    How to Prevent ORDER BY in Subqueries Being Ignored

    MySQL ignores ORDER BY inside subqueries without LIMIT.

    #mysql #orderby #subquery #howto #bug #sql

    youtube.com/watch?v=gqnEYUtf4Pk

    #mysql #orderby #subquery #howto #bug #sql
  6. PrecisionSQL @[email protected] ·

    How to Prevent ORDER BY in Subqueries Being Ignored

    MySQL ignores ORDER BY inside subqueries without LIMIT.

    #mysql #orderby #subquery #howto #bug #sql

    youtube.com/watch?v=gqnEYUtf4Pk

    #mysql #orderby #subquery #howto #bug #sql
  7. PrecisionSQL @[email protected] ·

    How to Prevent ORDER BY in Subqueries Being Ignored

    MySQL ignores ORDER BY inside subqueries without LIMIT.

    #mysql #orderby #subquery #howto #bug #sql

    youtube.com/watch?v=gqnEYUtf4Pk

    #sql #bug #howto #subquery #orderby #mysql
  8. PrecisionSQL @[email protected] ·

    How to Prevent ORDER BY in Subqueries Being Ignored

    MySQL ignores ORDER BY inside subqueries without LIMIT.

    #mysql #orderby #subquery #howto #bug #sql

    youtube.com/watch?v=gqnEYUtf4Pk

    #mysql #orderby #subquery #howto #bug #sql
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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

    #sqlwtf #sorting #sqlbugs #sqlshorts #codingchallenge #sqlquiz
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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

    #injectionattack #sqlwtf #databasedisaster #sqlshorts #productionbug #sqlfails
  21. 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
  22. Franck Pachot @[email protected] ·

    📎In the blog archives, a post from 2017 comparing Oracle and PostgreSQL #OrderBy
    franckpachot.github.io/pages/2

    #orderby
  23. Franck Pachot @[email protected] ·

    📎In the blog archives, a post from 2017 comparing Oracle and PostgreSQL #OrderBy
    franckpachot.github.io/pages/2

    #orderby
  24. Franck Pachot @[email protected] ·

    📎In the blog archives, a post from 2017 comparing Oracle and PostgreSQL #OrderBy
    franckpachot.github.io/pages/2

    #orderby
  25. Franck Pachot @[email protected] ·

    📎In the blog archives, a post from 2017 comparing Oracle and PostgreSQL #OrderBy
    franckpachot.github.io/pages/2

    #orderby
  26. Franck Pachot @[email protected] ·

    📎In the blog archives, a post from 2017 comparing Oracle and PostgreSQL #OrderBy
    franckpachot.github.io/pages/2

    #orderby