Convert Oracle SQL to MySQL

Oracle to MySQL swaps ROWNUM for LIMIT, NVL for IFNULL, the || operator for CONCAT() and SYSDATE 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.

SELECT p.product_id,
       NVL(p.name, 'untitled') AS name,
       p.code || '-' || p.rev AS sku
FROM products p
WHERE ROWNUM <= 100
ORDER BY p.product_id;

SELECT p.product_id,
       IFNULL(p.name, 'untitled') AS name,
       CONCAT(p.code, '-', p.rev) AS sku
FROM products p
ORDER BY p.product_id
LIMIT 100;