42.检查mysql数据库中没有创建主键的表的语句

select table_schema,table_name  from information_schema.tables where table_name not in(select  distinct table_name from information_schema.columns where COLUMN_KEY='PRI') and table_schema not in('mysql','sys','information_schema','performance_schema');