MySQL返回列名

SELECT GROUP_CONCAT(COLUMN_NAME SEPARATOR "+") FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = 'db_name' AND TABLE_NAME = 'tbl_name'

posted @ 2018-11-07 19:44  annofyf  阅读(751)  评论(0编辑  收藏  举报