查询存储引擎为MyISAM的表 ，查询所有没有主键的表

 

Data & safety于 2019-04-17 10:20:53 发布743 收藏

分类专栏： Mysql

 

Mysql专栏收录该内容

683 篇文章14 订阅

订阅专栏

select table_catalog
      ,table_schema
      ,table_name
      ,engine
from information_schema.tables
where engine='MyISAM';

查询所有没有主键的表

SELECT
table_schema,
table_name
FROM
information_schema.TABLES
WHERE
( table_schema, table_name ) NOT IN ( SELECT DISTINCT table_schema, table_name FROM information_schema.COLUMNS WHERE COLUMN_KEY = 'PRI' )
AND table_schema NOT IN ( 'sys', 'mysql', 'information_schema', 'performance_schema' );