Convert SQL Server to MySQL

SQL Server → MySQL example

Here is a real SQL Server query and the MySQL output Query Studio produces:

SELECT TOP 10 u.id, u.name, COUNT(o.id) AS orders
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
WHERE u.created_at > '2024-01-01' AND u.active = 1
GROUP BY u.id, u.name
HAVING COUNT(o.id) > 3
ORDER BY orders DESC;

SELECT
  u.id,
  u.name,
  COUNT(o.id) AS orders
FROM
  users u
  LEFT JOIN orders o ON o.user_id = u.id
WHERE
  u.created_at > '2024-01-01'
  AND u.active = 1
GROUP BY
  u.id,
  u.name
HAVING
  COUNT(o.id) > 3
ORDER BY
  orders DESC
LIMIT
  10

What changes from SQL Server to MySQL

• Identifier quoting is rewritten from bracketed [identifiers] to backtick `identifiers`.
• Row limiting is converted from SQL Server's TOP n to MySQL's LIMIT n, including any OFFSET for pagination.
• Null-handling functions such as ISNULL() are mapped to IFNULL().
• Current-timestamp functions like GETDATE() become NOW() / CURRENT_TIMESTAMP.
• The result is re-indented and keyword-cased in MySQL style so it's ready to paste and run.

How to convert SQL Server to MySQL

1. Open the Query Studio editor and choose SQL Server as the “From” dialect.
2. Choose MySQL as the “To” dialect.
3. Paste your SQL Server query and press Translate — copy the MySQL result.

SQL Server to MySQL FAQ

Other conversions