Learning Some MySQL Basics

MySQL is an open source database management system. (Say that ten times fast!) Since it’s so popular and it works so well with PHP, I’d be crazy not to learn how to use it! So here’s what I’ve learned so far:

MySQL uses SQL, the most popular language for working with database management systems. It looks pretty straightforward, with a number of commands for doing stuff like creating tables and retrieving data.

The MySQL manual has a whole section on the types of data that can be stored in a database. I don’t know anything about those data types yet, except that it’s important to use the right one.

Here are a few more links that I’ll probably look at later:

• MySQL & PHPMyAdmin - A screencast showing some basic MySQL commands through PHPMyAdmin, a useful tool for managing MySQL databases.
• PHP/MySQL Tutorial
• PHP MySQL at W3Schools

Anyway, I’m going to start working on a project soon, so I’ll be learning more about MySQL along the way.