Can you use Microsoft's SQL syntax in MySQL?

Question

I am learning to program with Microsoft SQL Server Management Studio Express (MSSMSE) at uni and I tried to use the same code from MSSMSE in MySQL and it comes up with lots of errors complaining about syntax.

I am using a mac so getting MSSMSE sadly isn't an option.

Does anyone know how to use the Microsoft SQL syntax on a mac?

Answer 1

If you were able to learn MSSQL Server syntax, learning MySQL will be easy for you. Just get a development environment going and get your hands dirty.

Answer 2

MS SQL and MySQL are very similar, but the syntax of each varies slightly. Knowing the syntax of one, you could easily write the other, but when you try to execute a statement from one language on another, you will get an error on the server because they are not identical, especially on long statements.

Answer 3

Get sunvirtualbox and virtualize windows xp and install SQL there and emulate that way, that's about as close to microsoft as you can go on mac for experience in ms software.