Differences between MySQL and SQL Server [closed]
One thing you have to watch out for is the fairly severe differences in the way SQL Server and MySQL implement the SQL syntax.
Here's a nice Comparison of Different SQL Implementations.
For example, take a look at the top-n section. In MySQL:
SELECT ageFROM personORDER BY age ASCLIMIT 1 OFFSET 2In SQL Server (T-SQL):
SELECT TOP 3 WITH TIES *FROM personORDER BY age ASC
Lots of comments here sound more like religious arguments than real life statements. I've worked for years with both MySQL and MSSQL and both are good products. I would choose MySQL mainly based on the environment that you are working on. Most open source projects use MySQL, so if you go into that direction MySQL is your choice. If you develop something with .Net I would choose MSSQL, not because it's much better, but just cause that is what most people use. I'm actually currently on a Project that uses ASP.NET with MySQL and C#. It works perfectly fine.
I can't believe that no one mentioned that MySQL doesn't support Common Table Expressions (CTE) / "with" statements. It's a pretty annoying difference.