SQL vs MySql

[Sir_Rimo]

Hi,
Can you please tell me the main differences between SQL Server and MySQL?
I'm learning SQL Server 2000 at the moment, but have no idea of what MySql is....
thank you very much...

[v0id]

First of all, your headline is not good.
You can't compare "SQL" and "MySQL". SQL is a language, while MySQL is a database.

MS SQL Server 2000 and MySQL are both databases, implementing the SQL-language. There is no big differences between the two databases. They both handles data. Of course there'll always be some differences between two products, but for a quick overview; they're doing the same stuff.

[Sir_Rimo]

First of all, sorry for that!
I meant MS SQL Server 2000 when I wrote SQL. we simply call it SQL in the class, and that causes the problem..
When I started the thread, I meant this:
we have a project which needs a database. Simply we don't use the MS Access for that, don't ask me why! it's not my fault!
I'm studying SQL and work with SQL Server 2000, so I know a bit about it. I want to know if MySql can help me instead of SQL Server 2000.
We don't need the file transfer or so. we just have a stand alone PC which runs the program. Is MySql good enough to handle a medium database?
What is the main difference of them? can we trust it for our project?
This is what I meant.
I'd be thankful to read your replies...
Thanks in anticipate,
Sir Rimo

[v0id]

To be honest I don't no much about databases in general, and haven't used them for a while, so I'm not the best to ask.

I've only been working with the MySQL database, and it's fast, secure and easy to use. And it should could handle a medium database. I can't say if it's better than MS SQL Server because I've no experience with it.

If I should choose one of these databases (MS SQL Server and MySQL) I would choose the MySQL-database.

Maybe someone in here can come with a more detailed description?

[Jordan]

The difference is that one is a free (largest used) database - MySQL while MS SQL is made by Microsoft and is intended for large scale database structures.

MySQL will do fine for a medium or even a large database and I prefer to use it because it runs on Linux. MS SQL isn't bad but I hate managing it with the GUI that it comes with. In the end you should probably choose the one you know best.

[Sir_Rimo]

Thank you both, you helped me a lot.
I'm going to give Mysql a try, I'll consult more with the tutorials and eBooks...
Thanks alot once more, I didn't think my questions will be answered this soon! good Site, Good Forums...
Thanks very much...

[WingedPanther]

I work with Firebird, MS SQL, and Oracle. I advise against Oracle whenever possible. It's painful to work with. MS SQL and MySQL will have slightly different syntax for advanced features, but should be comparable for a moderate number of users with pure SQL. You should avoid using Access if there is any chance of more than a handful of people using it at once, or even slightly complicated SQL queries. Access is a toy.

[Surgeon]

I would *definately* have to agree with pretty much everyone.

Use MySql, you are going to be using SQL for all of your queries really, just hopefully you have MySql 4+ on the server you are going to be messing with.

I have been recently developing in .net so, I use SQL Server 2005 express, but then I make the DAL and the BLL, and then I cry, then I program..

One other thing you may want to consider if you are using PHP5 or so, is SQLite, its not meant for large scale projects, it doesn't scale well thats for sure, but, for small/medium sized projects, it is absolutely fantastic. Try it out, its actually really cool.