Never used MySQL before? Start here! This tutorial walks you through the very basics of MySQL and SQL databases. Learn how to install MySQL, how to issue commands, and how to create and use databases.
MySQL for Absolute Beginners

A database is an essential part of most websites and blogs, but setting up and using a database can be a daunting task for the beginner web developer.
In this tutorial you'll learn — in simple terms — how to install, set up, and use a MySQL database on your computer. This will give you a good grounding in MySQL that you'll find useful when you start developing database-driven websites using PHP, Ruby, or your language of choice.
You'll explore the following areas in this tutorial:
  • The concept of a database, and why databases are useful
  • The advantages of using MySQL to manage your databases
  • How to install MySQL on your computer
  • Using the MySQL Monitor program to send commands to your MySQL server
  • How to create a database and table
  • SQL (Structured Query Language), and what it's used for
  • Adding records to a table, and retrieving records from a table
Ready to start exploring MySQL? Let's go!

What is a database?

database is a structured collection of data. Here are some typical examples of databases:
  • An online store database that stores products, customer details and orders
  • A database for a web forum that stores members, forums, topics and posts
  • A database for a blog system, such as WordPress, that stores users, blog posts, categories, tags, and comments
The software that manages databases is known as a database management system, or DBMS. MySQL is an example of a DBMS. Rather confusingly, DBMSs are often called databases too. Strictly speaking though, the database is the data itself, while the DBMS is the software that works with the database.
There are many different ways to organize data in a database, known as database models. One of the most popular is the relational model, which is what MySQL uses (along with PostgreSQL, Oracle, Microsoft SQL Server, and other common systems). Consequently, MySQL is known as a relational database management system, or RDBMS.
The following diagram shows how a database, the DBMS, and your website's code interact with each other.
Diagram of database, DBMS and website code
A database (left) is a collection of related data, managed by a DBMS such as MySQL (centre). Web scripts (right) communicate with the DBMS in order to insert, update, delete and retrieve data in the database.

MacBook Pro line getting revamped with MacBook Air style designs

There's rumors of a shakeup going around in Apple's laptop lines. AppleInsider claims, according to "people familiar with Apple's roadmap that Apple is aiming to completely revamp its notebook lines sometime this year, basically making the MacBook Air's style the standard. MacBook Pros would essentially be discontinued as we know them, and instead, the MacBook Pro would take on the Air format: Super thin, no optical drives, centered almost completely around digital distribution and portability. This is a story we've heard before
There has been word from overseas of a MacBook Air style notebook with a 15 inch screen coming out of the manufacturers in China, and this murmuring would seem to support those rumors. It's not much of a stretch, either -- the MacBook Air has been extremely popular (I've seen them almost replace any other Mac notebook models already at the two electronics conventions I've been to this year), and clearly customers have shown that they're ready to go with a slimmer model designed around downloading software rather than installing it from a disc.
Of course, there will always be holdouts: It's hard to believe that Apple will release a 17" MacBook Air-style model, and certainly there are plenty of users who would rather have a huge laptop that's almost used more as a desktop computer than something more portable. But this is Apple we're talking about -- have they ever waited for users to be comfortable with the new before moving forward?
At any rate, don't get too excited yet, as these are just rumors for now. But it does seem likely that by the end of this year, we'll see thinner, lighter laptops in Apple's portable computer lines.
Mywebscribbles © 2010 | Designed by Trucks, in collaboration with MW3, Broadway Tickets, and Distubed Tour