10 things in MySQL

(that won’t work as expected)

  1. Searching for a NULL

  2. LEFT JOIN with additional conditions

  3. Less than a value but not a NULL

  4. Joining on NULL

  5. NOT IN with NULL values

  6. Ordering random samples

  7. Sampling arbitrary record from a group

  8. Sampling first record from a group

  9. IN and comma-separated list of values

  10. LEFT JOIN with COUNT(*)

Via Explain Extended

ADDENDA: I would add two ones: One, the inability to determine whether a variable is full or Boolean value ( No Boolean choice ); and Two, minus one may equate to zero, both against one, considered both as verifiability conditions ( What the Hell? )
Newer Post Older Post Home