John Coggeshall's
MySQL Crash Course articles

 

John Coggeshall's MySQL Crash Course articles (the data for this list is collected and time-reordered from http://www.onlamp.com/onlamp/general/mysql.csp):

  • MySQL Crash Course, Part 1 by John Coggeshall
    Almost every serious web application uses a relational database to store its data. At some point, you'll have to learn how to use them. John Coggeshall explains the basics of relational databases with MySQL. Dec. 23, 2003
     

  • MySQL Crash Course, Part 2 by John Coggeshall
    Almost every serious web application uses a relational database to store its data. At some point, you'll have to learn how to use it. John Coggeshall explains how to change tables, select only the data you want, and delete rows from MySQL. Jan. 8, 2004
     

  • MySQL Crash Course, Part 3 by John Coggeshall
    Almost every serious web application uses a relational database to store its data. At some point, you'll have to learn how to use them. John Coggeshall explains how to make the most of the SQL SELECT statement across multiple tables. Jan. 29, 2004
     

  • Using MySQL from PHP, Part 1 by John Coggeshall
     

  • Using MySQL from PHP, Part 2 by John Coggeshall
    One of PHP's prime benefits is its close integration with databases, especially MySQL. Having explained the basics of MySQL, John Coggeshall turns his attention to demonstrating how to use MySQL from PHP. This week, learn how to count results, handle errors, and handle picky details. Mar. 18, 2004