SQL Converter · MySQL → SQLite

Convert MySQL SQL to SQLite

MySQL to SQLite drops `backticks`, swaps NOW() for datetime('now') and keeps IFNULL / LIMIT / group_concat. 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.

MySQL — source

MySQL

SELECT n.id, n.title,
       IFNULL(n.pinned, 0) AS pinned
FROM notes n
WHERE n.updated_at > NOW() - INTERVAL 7 DAY
ORDER BY n.updated_at DESC
LIMIT 50;

SQLite — converted

SQLite

SELECT n.id, n.title,
       IFNULL(n.pinned, 0) AS pinned
FROM notes n
WHERE n.updated_at > datetime('now', '-7 days')
ORDER BY n.updated_at DESC
LIMIT 50;

Convert your own query

What changes from MySQL to SQLite

MySQL	SQLite	Why
`identifier`	identifier	SQLite uses no backticks; double quotes or bare names.
NOW() - INTERVAL 7 DAY	datetime('now', '-7 days')	SQLite date math uses datetime() modifiers.
IFNULL / LIMIT	IFNULL / LIMIT	Both exist in SQLite and carry over unchanged.

Other SQL conversions

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