mysql小知识
时间:2022-03-15 08:33
-- 查询某数据库中所有表及其记录数
SELECT table_name,table_rows FROM information_schema.tables
WHERE TABLE_SCHEMA = ‘awreporting‘
ORDER BY table_rows DESC;
-- 查询某数据库中有某字段的表
SELECT table_name FROM information_schema.columns
WHERE table_schema = ‘awreporting‘ AND column_name LIKE ‘%AUTH_TOKEN%‘;