MySql/SQL program???

Hello,

I am wondering if there is any program that compile and run MySql/SQL in my computer like C++ (just running in my computer)? I want to play with SQL/MySql and php.

Thank you in advance.

 

MySQL is a database, and does not have a compiler. SQL is a query language, not a programming language and is compatible with all databases (Access, MySQL, Oracle etc.)
A free version of MySQL for various web servers (MS IIS, Apache etc.) is available at http://www.mysql.org/downloads/mysql/5.0.html#downloads
There are also some handy GUI tools available at http://www.mysql.org/downloads/gui-tools/5.0.html if you don't want to command line everything.

 

I wanted to add that PHP is also a scripting language (meaning it doesn't need to be compiled). I use PHP Designer as my editor, or "IDE" if you will.

http://www.mpsoftware.dk/phpdesigner.php

 

Thanks for the replies. I meant by compile like a program that I can run and play with MySQL and php on my computer without having to buy a server. Does any those programs work like that? Meanwhile I will download and see if i can work it out.

 

Yes, you can install MySql on any PC and access databases and play around, I use C# for my work, just download SharpDevelop, MySql and then the .Net Data access program.

 

Apache is the most popular free HTTP webserver. Just download and install that, then install MySQL and PHP and you will be able to create dynamic webpages on your local server.

 

Again, SQL isn't a programming language, and you can't make a SQL program.
Typically you have a database server (such as MySQL) running somewhere (often it can run just fine on your local PC), and then your program (written in C++, PHP, Java or anything else) creates a connection to the database, and sends SQL commands to it. the program might be a regular .exe file you wrote in C++, or it may be a php program lying on a webserver waiting for a user to access it.

Not sure what exactly you mean by "have to buy a server" though.
If you're talking about a physical computer to act as your server, there's no need for that. The software doesn't care whether it's running on your notebook, your desktop, a server at some web hosting company, or your own dedicated server. You only need to place it on a physical server if you have some serious performance needs.

The MySQL software is a database server though, and you will need one of those. (A server is just something that *serves* a bunch of clients. It doesn't have anything to do with physical hardware, although it may be convenient to place large servers on their own machine)
The MySQL server software is free for most purposes though, so you won't need to buy that either.

Since I assume you're going to use PHP for web development, you will need a web server too (which, again, is just software). And as said above, Apache is a free webserver which works very well with PHP and MySQL (which are also free)

Hope that made sense.

 

Thanks alot .. REP+ for all. Sorry for not being clear about buying, i meant getting a domain for it. Hopefully, I get to work and play with this weekend.

 

ooh, a domain. Right.
(You know the domain isn't the same as hosting for it, right? The domain gives you permission to use a certain domain. You still need to have your site hosted somewhere, although a lot of hosts offer to buy the domain for you as well)

But yeah, no need to get any of that until your website is ready.

Anyway, good luck with it, and have fun