返回首页
SQL格式化与压缩工具
支持MyBatis占位符、问号参数，清新设计风格
支持所有JOIN类型
支持问号参数
无多余空行
复制功能
SQL输入区
SELECT u.id, u.name, u.email, o.order_date, o.total FROM users u LEFT JOIN orders o ON u.id = o.user_id RIGHT JOIN payments p ON o.id = p.order_id INNER JOIN customers c ON u.customer_id = c.id FULL OUTER JOIN invoices i ON c.id = i.customer_id WHERE u.status = ? AND o.total > #{minTotal} AND o.order_date BETWEEN ${startDate} AND #{endDate} GROUP BY u.id HAVING COUNT(o.id) > 3 ORDER BY o.total DESC;
格式化结果
复制
已格式化
格式化SQL
压缩SQL
重置内容