SELECT
field
FROM
(
SELECT
CONCAT( column_name, ',' ) AS field,
ORDINAL_POSITION AS a1,
lead( ORDINAL_POSITION, 1 ) over ( ORDER BY ORDINAL_POSITION ASC ) AS a2
FROM
information_schema.COLUMNS
WHERE
table_schema = 'decent_cloud'
AND table_name = "t_sale_from"
ORDER BY
ORDINAL_POSITION ASC
) m
WHERE
m.a2 IS NOT NULL UNION ALL
SELECT
field
FROM
(
SELECT
column_name AS field,
ORDINAL_POSITION AS a1,
lead( ORDINAL_POSITION, 1 ) over ( ORDER BY ORDINAL_POSITION ASC ) AS a2
FROM
information_schema.COLUMNS
WHERE
table_schema = 'decent_cloud'
AND table_name = "t_sale_from"
ORDER BY
ORDINAL_POSITION ASC
) m
WHERE
m.a2 IS NULL
mysql 用 “字段” 代替“*” 查询sql
于 2023-06-15 17:57:33 首次发布