SQL格式化工具 - 在线美化、压缩SQL语句，SQL关键字大写转换 -在线工具大全

请在下面输入要 "SQL格式化" 的字符或文本 :

SELECT u.EmployeeID, u.LoginName, u.PWD, u.UserID, COALESCE (e.Age, 0) AS Age, COALESCE (e.Email, '') AS Email, COALESCE (e.EmployeeName, '') AS EmployeeName, COALESCE (e.HISEmployeeID, '') AS HISEmployeeID, COALESCE (e.IsEnable, b'1') AS IsEnable, COALESCE (e.JobTitle, '') AS JobTitle, COALESCE (e.OrganizationID, '') AS OrganizationID, COALESCE (e.Phone, '') AS Phone, COALESCE (e.Sex, '') AS Sex, COALESCE (e.Tel, '') AS Tel, COALESCE (ed.Photograph, '') AS Photograph, COALESCE (ed.SgFingerPrint1, '') AS SgFingerPrint1, COALESCE (ed.SgFingerPrint2, '') AS SgFingerPrint2, COALESCE (ed.SgFingerPrint3, '') AS SgFingerPrint3, ed.FaceInfo, ed.fsi FROM ( SELECT * FROM sys_user WHERE IsValid = 1 AND Userid IN ( SELECT Userid FROM sys_user_role WHERE roleid IN ( SELECT roleid FROM sys_role WHERE MachineType IN ( SELECT MachineType FROM sys_machine WHERE MachineId = '60000001' ) ) ) ) u LEFT JOIN sys_employee AS e ON u.EmployeeID = e.EmployeeID AND e.IsEnable = 1 LEFT JOIN sys_employee_detail AS ed ON ed.EmployeeID = e.EmployeeID

SQL格式化

相关功能

最近查询记录