Thursday, July 2, 2009

Creating a database with phpMyAdmin


I've been trying to get started creating the database I need for this project. I have it planned out on paper, but it's time to get it digitized, and I'm finding it hard to get any traction with MySQL. I've been spending a lot of time looking for tutorials and books, which I'll need, but many of these resources seem to start in the middle somewhere. I'm the kind of learner who gets cranky if information starts getting thrown at me without the foundational understandings already being in place.

Most of the tutorials I find have you importing a sample database from somewhere, leaving out the step of creating one. So I really just wanted a very simple, nice, friendly tutorial on how to create a database with phpMyAdmin.

Here's the one I found: www.homeandlearn.co.uk/php/php12p2.html

It explains in just a few words - not three chapters that go off in every direction - what those data types are, and how to choose which. That helped me a lot.

So - I have a database now, and one table. phpMyAdmin served me well for this, but I may try and switch to Heidi, because the interface is just so much nicer, as people told me. Not sure, because so many tutorials and instructions are written for phpMyAdmin.

Next: creating the other two database tables I need. Next after that: figuring out what's next after that.