SQL Server to MySQL

Just completed a fairly painless transition from SQL Server to MySQL. I used the very useful MSSQL2MySQL. No Triggers, Views or any other complicated stuff. In rewriting the SQL itself the only problems I had were with built in functions and the TOP command.

SQL Server to MySQL equivalent functions:

ISNULL => IFNULL (same syntax)
GETDATE => NOW (not CURDATE as that doesn't include the time)
SELECT TOP x => LIMIT x (at the end of the statement not after SELECT)
DATEADD => DATE_ADD

One Reply to “SQL Server to MySQL”

  1. Thanks! This has been doing my head in for weeks, trying to get to grips with MySQL can be frustrating at times!

Leave a Reply

Your email address will not be published.