-- 查看数据库中有大写的表
SELECT table_schema,table_name FROM information_schema.tables
WHERE table_schema NOT IN ('sys', 'mysql', 'performance_schema', 'information_schema', 'test')
AND table_name REGEXP BINARY '[A-Z]';
-- 查看数据库中有大写的表
SELECT table_schema,table_name FROM information_schema.tables
WHERE table_schema NOT IN ('sys', 'mysql', 'performance_schema', 'information_schema', 'test')
AND table_name REGEXP BINARY '[A-Z]';