-- mysql实现方法
SELECT CONCAT(
'SELECT ',
GROUP_CONCAT(COLUMN_NAME ORDER BY ORDINAL_POSITION SEPARATOR ', '),
' FROM your_table_name;'
) AS select_query
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'your_table_name'
AND TABLE_NAME = 'your_table_name';
-- 达梦实现方式
SELECT 'SELECT ' || LISTAGG(COLUMN_NAME, ', ') WITHIN GROUP (ORDER BY COLUMN_ID) || ' FROM your_table_name;'
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'your_table_name';