SELECT
table_name, column_name, index_name, count(table_name) as index_count
FROM
information_schema.statistics
WHERE
index_name != 'primary'
AND
table_schema = 'your_database'
GROUP BY
table_name
查询哪些表有唯一索引(除了主键)
最新推荐文章于 2024-04-02 18:30:00 发布