查询表的列名

SELECT COLUMN_NAME FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = 'xxxxx' AND TABLE_NAME = 'xxxx';

posted @ 2021-03-12 14:37  周周和奇奇  阅读(54)  评论(0编辑  收藏  举报