Register to reply

Does Microsoft have a free version of MySQL?

by Hodgey8806
Tags: free, microsoft, mysql, version
Share this thread:
Hodgey8806
#1
Jan2-13, 04:55 PM
P: 130
I am wanting to gain experience with SQL without buying a license. I am planning to buy a program that shows you how to create databases as well as write code for them. However, this program requires that I have an SQL setup to use.

I saw that Microsoft has a MySQL download but I'm not sure it is what I need for the program specifically....I just need to be able to access a way to write codes and try it out.

Any help would be great!

Thank you :)
Phys.Org News Partner Science news on Phys.org
Mysterious source of ozone-depleting chemical baffles NASA
Water leads to chemical that gunks up biofuels production
How lizards regenerate their tails: Researchers discover genetic 'recipe'
DavidSnider
#2
Jan2-13, 05:02 PM
PF Gold
P: 469
Microsoft makes SQL Server not MySQL. SQL Express is the free version of Microsoft SQL Server.
StevieTNZ
#3
Jan2-13, 05:32 PM
PF Gold
StevieTNZ's Avatar
P: 800
I've used Visual Studio 2010 Express in my web design course, which involved SQL code. You can download that for free from Microsoft.

John Creighto
#4
Jan2-13, 10:03 PM
P: 813
Does Microsoft have a free version of MySQL?

Some thoughts. Here are some free versions of SQL

MySQL
- is popular for PHP programmed websites
- there is a version of PHP which runs inside of java
SQL light
- is integrated into the android office system
HyperSQL
- is used in open office applications.
- allows you to program database triggers
- is programmed in java

This is just some facts off the top of my head. Google is your friend.

-----------------

On another note, with regards to programming, a lot of these systems will have common functionality. If you are wring a program, you can write an interface and adapt it to each type of SQL. This will make your code easier to port from one type of database to another. One especially powerfully way to do this is to construct queries pragmatically. This is especially easy to do if the language supports lambda expressions:
http://geekswithblogs.net/samerpaul/...in-c-linq.aspx
jtbell
#5
Jan3-13, 08:09 AM
Mentor
jtbell's Avatar
P: 11,745
mysql.com has the freely downloadable MySQL Community Server:

http://www.mysql.com/downloads/

That page has a prominent link to a "MySQL Installer for Windows." I can't try it because I'm on a Mac.

On a Mac, MySQL installs via the standard MacOS clickable package mechanism, and you can run SQL commands via the basic command-line interface by invoking the 'mysql' command at the command line in a MacOS Terminal window. I imagine there's something similar for a basic Windows setup.
Adyssa
#6
Jan5-13, 11:16 PM
P: 188
There are different ways to interface with the database manager, it depends on how you plan to use MySQL. The easiest way is, as jtbell mentioned, to run MySQL from the command line - this works in Windows too. If your program is teaching MySQL specifically, I'm sure it will spell this out for you.

Otherwise, you can write programs (Java, .NET, etc) to interface with your database. Or you could run a web server and create a web page to handle it. You can install a complete Apache, MySQL, PHP stack without too much fuss.


Register to reply

Related Discussions
Microsoft Office 2007 Version Engineering, Comp Sci, & Technology Homework 3
Microsoft Math 2007 - What's new in this version? Math & Science Software 2
The adventure of physics - new version for free download General Physics 0
Microsoft announces newest version of Flight Simulator Computing & Technology 2
New version of free physics text available General Physics 0