SELECT
*
FROM
information_schema.`TABLES` t
LEFT JOIN information_schema.STATISTICS s ON t.TABLE_SCHEMA = s.TABLE_SCHEMA
AND t.table_name = s.TABLE_NAME
AND s.INDEX_NAME = 'PRIMARY'
WHERE
t.TABLE_SCHEMA NOT IN (
'mysql',
'performance_schema',
'information_schema',
'sys'
)
AND TABLE_TYPE = 'BASE TABLE'
AND s.INDEX_NAME IS NULL;
深入理解MySQL——查看没有创建索引的表
最新推荐文章于 2022-07-29 15:43:53 发布