mysql 判断所有表或表字段包含大写的写法: BINARY + REGEXP select * from information_schema.COLUMNS where table_schema <> 'information_schema' and ( BINARY table_name REGEXP '[A-Z]' or BINARY column_name REGEXP '[A-Z]' );