Code Snippets

MySQL Snippets

The joins and the gotchas, copy-pasteable - the queries that are easy to get subtly wrong and the reasons they go wrong.

Everything in MySQL Snippets

  • Diagram: three grouped rows of records, two intact and one struck through entirely because a single row inside it matched the excluded value.

    12/21/2014

    MySQL: exclude a whole group when any row matches

    Querying databases get a little tricky when you have a stack of records associated with another table, perhaps a master table of accounts, and you’re trying to filter out values that would exclude the results from…