It is now 2:30 and I really have spent close to four hours working with MySQL. I used phpMyAdmin for the first part of the session and followed the directions to create the special relation table that allows you to make relational links. I also added a few records to see how the linking works and immediately discovered that I was unable to do one-to-many relationships.
I spent the past hour or so working with MySQL in the MySQL monitor window, typing commands and I think that may be how I continue for now. While it’s tempting to have a GUI interface, I think I need to really learn from scratch. So, tomorrow (or maybe late tonight while I watch the tape of the debate), I am going to start working on Chapter 4 in Ullman’s book using the monitor window.
Of course, I have nothing to show for this since I’m doing it all locally!
