Mysql查出没有主键的表

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','wechat','information_schema','performance_schema' #排除系统库和你要排除的库
);

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','wechat','information_schema','performance_schema' #排除系统库和你要排除的库

);

本文固定链接: https://www.yoyoask.com/?p=1828
转载请注明: shooter 2018年01月15日于 SHOOTER 发表

最后编辑：2020-01-15

作者：shooter

这个作者貌似有点懒，什么都没有留下。

站内专栏

您可能还会对这些文章感兴趣！