« 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
Do you have your own favorite MySQL question? Is there something in MySQL that has you scratching your head? Send your ideas for new pop quiz questions to carsten (at) bitbybit (dot) dk. Send it in, even if you don’t know the answer — that only makes it more interesting.
More Pop Quiz entries: WWW or RSS.