SQL Converter · T-SQL → MySQL

Convert T-SQL SQL to MySQL

SQL Server to MySQL swaps TOP for LIMIT, [brackets] for `backticks`, ISNULL for IFNULL and GETDATE() for NOW(). A mechanical formatter only re-indents — it won’t rewrite dialect-specific syntax. The AI converter in the app translates the query and the table below shows exactly what changes.

T-SQL — source

T-SQL

SELECT TOP 15 c.Name,
       ISNULL(c.Phone, 'n/a') AS phone
FROM dbo.Customers c
WHERE c.CreatedAt > GETDATE() - 30
ORDER BY c.Name;

MySQL — converted

MySQL

SELECT c.Name,
       IFNULL(c.Phone, 'n/a') AS phone
FROM Customers c
WHERE c.CreatedAt > NOW() - INTERVAL 30 DAY
ORDER BY c.Name
LIMIT 15;

Convert your own query

What changes from T-SQL to MySQL

T-SQL	MySQL	Why
TOP 15	LIMIT 15	Row limiting moves from a leading TOP to a trailing LIMIT.
[dbo].[Customers]	`Customers`	MySQL has no schema-owner brackets; use backticks.
ISNULL / GETDATE()	IFNULL / NOW()	T-SQL-only functions map to their MySQL equivalents.

Other SQL conversions

T-SQL → PostgreSQL PostgreSQL → MySQL Oracle → MySQL T-SQL → Snowflake All conversions →