我目前正在使用以下查询从单个mysql表中获取列名

SELECT COLUMN_NAME as column_name
    FROM INFORMATION_SCHEMA.COLUMNS
        WHERE TABLE_NAME = 'product'
            AND COLUMN_NAME
                NOT IN ('ean','jan','isbn','mpn','upc');


如何从多个表中获取列名?在这种情况下,有没有类似JOIN的选项?

最佳答案

SELECT COLUMN_NAME as column_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE (TABLE_NAME = 'product' AND COLUMN_NAME NOT IN ('ean','jan','isbn','mpn','upc'))
   OR (TABLE_NAME = 'other_table' AND COLUMN_NAME NOT IN ('something_else'))

关于mysql - 如何在mysql中获取两个表的列名?,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/33124160/

10-12 00:13
查看更多