In part 2 of his "MySQL Crash Course" series, John Coggeshall builds on his previous article and moves on to introduce the UPDATE, DELETE, ALTER, and DROP statements, as well as a few new clauses to the SELECT statement.

Although I will not be discussing any PHP code today, these concepts are requirements before we can move forward. He continues through the SELECT statement, introducing the WHERE clause and modifiers such as LIKE. Next to be introduced is the UPDATE, DELETE, and ALTER statements and how to use the "new" WHERE clause with each.

Although we have barely scratched the surface of everything that can be done with an RDBMS such as MySQL, at this point I have introduced every statement that is of immediate use to you. Of course, for those of you who would like a more information, the MySQL web site is an excellent resource.