Jump to content

Where do I start?


coolgamer48
 Share

Recommended Posts

Hey everyone,Okay - this is my first forum post. I just read through the SQL tutorial on W3 schools, and I want to try out SQL commands? What do I do? Could someone please tell me how to get from reading the tutorial to a place where I can actually use SQL commands. Also, I guess beggars can't be choosers, but please don't post things like "search free SQL hosting on Google". I've spent hours looking on the internet and got pretty much nowhere. So if possible, can you give specific sites that you found useful.Thanks!

Link to comment
Share on other sites

Well, you can download an SQL implementation such as that contained in a AMP package, such as EasyPHP. Then (assuming you are using windows) use the command prompt (C:\windows\system32\command.com) and navigate to the mySQL\bin folder inside your installation. Run "mysql -u<username> -p<password>" and you will get the SQL query interface. Start commanding! :)

Link to comment
Share on other sites

Well, on the localhost your databases are stored on your computer - no external host needed :). I think the default username and password for EasyPHP is "root" and "", so try

mysql -uroot

Remember, SQL is just a type of database, like Access, and is not necessarily reliant on a third-party host. Your computer is he host in this case :)

Link to comment
Share on other sites

if you're just in to learning some SQL, and aren't up to work too hard to get started there are packages with free open software to get you started locally on you computermacmamp - http://www.mamp.info/en/index.php and a sql client like http://cocoamysql.sourceforge.net/ (phpMyAdmin is included in mamp, if that suffice)windowsxampp - http://www.apachefriends.org/en/xampp-windows.htmlsql client like http://www.heidisql.com/linuxnot sure.. but http://lamphowto.com/ looks like a place to start. google is also your friend. the key word is lamp (linux, apache, mysql, php)

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...