Quote:
|
Originally Posted by Greg Marra
Does anyone have a nice introduction to MySQL?
I am working on a project, and have decided to move up from flat file databases to the real deal, only now I'm a bit stuck. It could be partly because it's 11:30 at night, but I really don't know anything about MySQL, so I need to teach myself a little.
Anyone with a good tutorial would be appreciated.
|
Greg,
If I had to recommend some books, there are two I've learned a great deal from. I prefer them over free tutorials, because often times, I've found that I need a large number of websites to become even moderately comfortable with broad topics, but a couple of handy books seem to provide everything in one place and even tell me things I didn't know I needed to know (If that makes any sense?) These two titles are around $13 and $22 respectively...
Beginning PHP4 - Despite the title, this book is actually half PHP and half SQL. It definitely gives a good start of the fundamentals, from creating databases, variable types, organizing data, optimizing queries. I have a half dozen tabs indexing what I use most often and it provides a good transition between PHP and MySQL. The examples are pretty practical.
MySQL Cookbook - Once you get things going, this book answers a lot of common, "How do I....?" questions with full examples. If you're doing things quick and dirty and need snippets, this is a great title. I found it to be very useful.
Good luck!
Matt