mysql 查询数据库中含有某个字段的表名

sql:

##  asset 是数据库名  sale_code 是表字段 
SELECT 
        TABLE_NAME AS '表名',
        COLUMN_NAME AS '字段名',
        DATA_TYPE AS '数据类型',
        IS_NULLABLE AS '是否可为空'
    FROM information_schema.COLUMNS 
    WHERE TABLE_SCHEMA = 'asset' 
    AND COLUMN_NAME = 'sale_code'
    ORDER BY TABLE_NAME;

 

over