Beginning MySQL Tutorial

This article is fantastic. It really helped me get a jump start on mysql.

Thanks for a great job. It really helps me to start understanding Mysql. More down to earth than the official document.

Really hard to find a good MySQL tutorial... Saved me quite a bit of time getting things up and running... Thanks!

It's a great help. Any chance of a printable version?

This was a great easy to follow Introduction to SQL Thanks!

I always come back to find the way to do queries the simple way.

Thanks for the easy to understand tutorial!
Let's say I needed to store information on
what people have bought from a company in
the past. Each person may have bought more
than one item from us so storing the information
in a single text field would be difficult.
How would I go about this?

This is pretty easy to do, but the database you create will have to be designed to accommodate it. You will need 2 different tables, one to store a record for each 'person' and one for each 'purchase,' you can then link those 2 tables together with a common field. For example, the person table would have a personID, personName, etc. The purchase table should contain purchaseID, personID, purchaseAmount, etc. These two tables both have the common field personID. This allows you to have a one to many relationship. You can do all sorts of fun things with JOINs once your database is set up like this. See: http://www.mysql.com/Manual_chapter/manual_Reference.html#JOIN for more information on JOINs in MySQL.

Thanks for the great article. Considering the overabundance of database information on the Web, you guys really helped me concentrate on what needs to be learned without having to wade through all the unneccesary details.

once you've got the database installed on your system of course...

Love the new look site, inspiration as always.. keep it up. I'll be back.

Surrey , Uk

Great Article. I have been reluctant to dive into this SQL stuff. I was able to get my database up and running the same day!

I wish man pages were like this
Robert.

Im a professional programmer interested in expanding my capabilities. I am currently
doing this by investigating mySQL, and am very impressed with the technology. This
page has given me the direct information I was interested in, making it easy to get started and quick to get a solid basic understanding of the DBMS.

Thanks.

Hi !..I am impressed by the simple yet very robust feature of mysql..i am realy novice in mysql..i find this tutorial very intutive and help me to gain a lot about mysql in very short span of time..i hope the author will provide us with more practical and illustrative example to make the tutorial more intersting..
Thnks

The article here was greate for explaining setting up the database... I hope there is more expansion later about CGI interfacing with the database.. The MySQL manual is quite comprehensive, however, I think examples go much further.
<br>
<br>
I did experience one problem while going through the tutorial. I'm running Win32 MySQL server and if I set up a password on the root account and attempt to drop a database, I get prompted for a password. I enter it and when I hit enter, for some reason it takes the <CR> twice and automatically answers the <y/N> for 'do you really want to do this?' with a No. The only way I can drop a database is by removing the root password, then it works fine.
<br>
Server Version: 3.21.29a-gamma-debug

This article really help! But I would like to know is there any other client (command mode) to connect to remote MySQL server?

thanks


porsche