In our last episode we covered sorting, searching and grouping. We found out that using the COUNT(*) can be problematic when we have unexpected NULL data. Now we look at how to resolve data issues by updating the data, and perhaps even the table schema.… more »
MySQL 101 - Sorting and Searching: ORDER BY, WHERE, GROUP BY
In our last episode we were able to select some information from our bookshop database, this time we look at putting this into some semblence of order. To fully investigate this topic we need a few more entries in our database, so rather than detail… more »
MySQL 101 - Retrieving data: SELECT and JOIN
In our last episode we started building up our online bookshop database, with tables for publishers, authors, formats and books. At the moment we only have one book in there, so before we go too far, lets add a few more: INSERT INTO `book` VALUES (… more »
MySQL 101 - Creating your first database
In our last episode we found out how to connect to a MySQL server. This time we learn how to lay out a database and start creating it. For this, and following episodes, we will be looking at creating a database to support an online bookshop. Creating… more »
MySQL 101 - Connecting to a MySQL server
In our last episode we looked at getting MySQL, today we will be looking at how you connect to a MySQL server and what that implies. Connection basics Before a client can connect to a MySQL server it needs a path by which that connection can be made.… more »