« TRUNCATE :: MySQL Function of the Day | Main | LOG() :: MySQL Function of the Day »
MySQL Pop Quiz #25
By Carsten | April 23, 2008
I’m still looking for new entries. I get quite a few suggestions, but not all of them make it into quiz questions. Do send in your suggestions!
This quiz on INFORMATION_SCHEMA is stolen (with permission!), from Roland:
- Specify a minimal set of columns of the
information_schema.TABLE_CONSTRAINTStable that is sufficient to reliably identify a single row in theinformation_schema.TABLE_CONSTRAINTStable. - Argue why these columns are necessary and sufficient to identify a row, and why a smaller set of columns does not exist
For more background information on the question, as well as several shots at possible answers, see Rolands original entry.
For the correct answer, see Rolands followup
[popps]