O'Reilly logo

Learning PHP, MySQL, and JavaScript by Robin Nixon

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Test Your Knowledge: Questions

Question 8-1

What is the purpose of the semicolon in MySQL queries?

Question 8-2

Which command would you use to view the available databases or tables?

Question 8-3

How would you create a new MySQL user on the local host called newuser with a password of newpass and access to everything in the database newdatabase?

Question 8-4

How can you view the structure of a table?

Question 8-5

What is the purpose of a MySQL index?

Question 8-6

What benefit does a FULLTEXT index provide?

Question 8-7

What is a stopword?

Question 8-8

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?

Question 8-9

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?

Question 8-10

What needs to be defined in two tables to make it possible for you to join them together?

Question 8-11

Observant readers may have noticed that three book publication dates are incorrect in this chapter. Pride and Prejudice was actually published in 1813, The Origin of Species in 1859 and Romeo and Juliet in 1597. How could you correct these entries?

See the section Chapter 8 Answers in Appendix A for the answers to these questions.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required