Sams Teach Yourself SQL in 21 Days, Fourth Edition

Workshop

The Workshop provides quiz questions to help solidify your understanding of the material covered, as well as exercises to provide you with experience in using what you have learned. Try to answer the quiz and exercise questions before checking the answers in Appendix A, “Answers.”

Quiz

1:	Why was MySQL first developed?
2:	How do you start the mysql daemon?
3:	How do you stop the mysql daemon?
4:	Which commands/elements in MySQL Terminal Monitor are case sensitive?

Exercises

1:	Enter the MySQL command to display the database names from the UNIX prompt, as well as from the MySQL Terminal Monitor.
A1:	# /usr/local/mysql/bin/mysqlshow +-----------+ | Database | +-----------+ | mysql | | test | +-----------+ 2 rows in set (0.00 sec) # mysql -u ...