Sams Teach Yourself PHP, MySQL® and Apache All in One

Workshop

The workshop is designed to help you anticipate possible questions, review what you've learned, and begin learning how to put your knowledge into practice.

Quiz

1:	The integer 56678685 could be which datatype(s)?
2:	How would you define a field that could only contain the following strings: apple, pear, banana, cherry?
3:	What would be the LIMIT clauses for selecting the first 25 records of a table? Then the next 25?
4:	How would you formulate a string comparison using LIKE to match first names of “John” or “Joseph”?
5:	How would you explicitly refer to a field called id in a table called table1?
6:	Write a SQL statement that joins two tables, orders, and items_ordered, with a primary key in each of order_id. From the orders table, select the following ...