What is the purpose of the semicolon in MySQL queries?
Which command would you use to view the available databases or tables?
How would you create a new MySQL user on the local host called
newuser with a password of
newpass and with access to everything in the
database newdatabase?
How can you view the structure of a table?
What is the purpose of a MySQL index?
What benefit does a FULLTEXT
index provide?
What is a stopword?
Both SELECT DISTINCT and
GROUP BY cause the display to show
only one output row for each value in a column, even if multiple rows
contain that value. What are the main differences between SELECT DISTINCT and GROUP BY?
Using the SELECT...WHERE
construct, how would you return only rows containing the word
Langhorne somewhere in the author column of the classics table used in this chapter?
What needs to be defined in two tables to make it possible for you to join them together?
See Chapter 8 Answers in Appendix A for the answers to these questions.