SQL (newb question)

[NotAGolf]

Hi,

First off, sorry if this is in the wrong section. I couldn't decide between here or the programming section.

I want to get to grips with databases. I just want to make a simple database with a few tables, just so i can practice some basic database work, and start to learn some SQL and then integrate some PHP.

I downloaded mySQL thinking that I should be able to do these tasks on it. But unless I'm being stupid (which is very possible!) don't you have to have some sort of online web space that I can store the database on? I dont want to do this, I just want something local on my computer that I can practice on offline. Surely there's a way to do this?

Could someone give me a bit of info of the situation as I'm really clueless right about now! I'm willing to use any database software as long as it's free. The more popular the better.

Thanks.

 

[marc2003]

you can download the GUI tools for mysql to work on the database locally. and you could even install and run your own webserver and php to play with.

you can even get this all packaged together. have a look at WAMP.

 

[Steve09]

As Marc said, get WAMP:

http://www.wampserver.com/en/download.php

Download WampServer 2.0i it's all you need.
It will give you Apache(Local Webserver), MySQL and PHP.
It'll also install PHPMyAdmin for setting up your databases etc.

You'll need something like Notepad++ or ConTEXT as your PHP text editor if you don't have one.

 

[NotAGolf]

Thanks guys. Just got it installed and I've started having a play. I can create tables at least so that's a start!!