MySQL下批量排查无主键表

jiawang

SELECT TABLE_SCHEMA, TABLE_NAME
FROM information_schema.tables t
WHERE t.TABLE_SCHEMA NOT IN ('mysql','information_schema','performance_schema','sys')
  AND NOT EXISTS (
    SELECT 1 FROM information_schema.table_constraints tc
    WHERE tc.table_schema=t.table_schema
      AND tc.table_name=t.table_name
      AND tc.constraint_type='PRIMARY KEY'
  );
可快速列出所有无主键表，建议尽快修复。