SQL translator › T-SQL → MySQL
SQL Server to MySQL translator
The other direction. Useful when the analyst lives in SSMS and the client lives on RDS MySQL.
Usual swaps
| SQL Server | SQL Server |
|---|---|
| TOP n | LIMIT n |
| OFFSET FETCH | LIMIT offset, count |
| ISNULL | IFNULL |
| GETDATE() | NOW() |
| DATEADD(day, n, d) | DATE_ADD(d, INTERVAL n DAY) |
| STRING_AGG | GROUP_CONCAT |
| IIF | IF |
| [brackets] | backticks |
| IDENTITY | AUTO_INCREMENT |
nvarchar becomes varchar with a utf8mb4 charset. bit becomes tinyint(1).
Then write it on a ticket
Monday is free. A colleague asks, you type, we mark it.
Clock in free