获取缺失主键表信息的MySQL语句

这篇文章主要为大家详细介绍了获取缺失主键表信息的MySQL语句，具有一定的参考价值，可以用来参考一下。

对此感兴趣的朋友，看看idc笔记做的技术笔记！

代码如下:

 
SELECT a.`TABLE_SCHEMA` AS DB_NAME , a.`TABLE_NAME` , a.`TABLE_ROWS` ,a.`ENGINE` -- , a.* 
FROM 
information_schema.`TABLES` a 
LEFT JOIN information_schema.`TABLE_CONSTRAINTS` b 
ON a.`TABLE_NAME` = b.`TABLE_NAME` AND a.`TABLE_SCHEMA` = b.`TABLE_SCHEMA` 
WHERE b.`TABLE_SCHEMA` IS NULL 
AND a.`TABLE_TYPE` = 'BASE TABLE' 
AND a.`TABLE_SCHEMA` NOT IN ('information_schema','test','mysql','performance_schema') 
ORDER BY DB_NAME ,a.`TABLE_ROWS` DESC ; 

注：关于获取缺失主键表信息的MySQL语句的内容就先介绍到这里，更多相关文章的可以留意