SELECT
CONCAT(
"SELECT ",
GROUP_CONCAT(COLUMN_NAME SEPARATOR ' , '),
" FROM ",
"表名"
) as full_select_sql
from
information_schema.COLUMNS
WHERE
TABLE_NAME = '表名'
ORDER BY ORDINAL_POSITION ASC
MySQL 生成select完整列语句
最新推荐文章于 2024-09-27 20:43:28 发布