sql格式化工具

最新推荐文章于 2024-09-09 23:37:05 发布

sanzk

最新推荐文章于 2024-09-09 23:37:05 发布

阅读量85

点赞数 1

文章标签： sql java 数据库

本文链接：https://blog.csdn.net/qq_25194681/article/details/142071688

版权

1.在线格式化工具:
https://www.qianbo.com.cn/Tool/Beautify/Sql-Formatter.html

2. 格式化后用@拼接

        string sql = @"
SELECT 
    rack.rackRow,
    rack.rackColumn,
    rack.rackLayer
FROM 
    rack
LEFT JOIN TaskList
    ON rack.rackColumn = TaskList.Unload_Col
        AND rack.rackRow = TaskList.Unload_Line
        AND rack.rackLayer = TaskList.Unload_Layer
LEFT JOIN TaskList0
    ON rack.rackColumn = TaskList0.Unload_Col
        AND rack.rackRow = TaskList0.Unload_Line
        AND rack.rackLayer = TaskList0.Unload_Layer
WHERE 
    rack.used = 0 
    AND (
            (
            TaskList.Unload_Col IS NULL
            AND TaskList.Unload_Line IS NULL
            AND TaskList.Unload_Layer IS NULL
            ) 
        OR (TaskList.Excute = 1)
        )
    AND (
        TaskList0.Unload_Col IS NULL
        AND TaskList0.Unload_Line IS NULL
        AND TaskList0.Unload_Layer IS NULL
        )
ORDER BY 
    rack.rackRow, 
    rack.rackLayer 
LIMIT 1;