Memo for MySQL

列出某 schema 中的所有 Index

SELECT
    DISTINCT TABLE_NAME,
    INDEX_NAME
FROM
    INFORMATION_SCHEMA.STATISTICS
WHERE
    TABLE_SCHEMA = '{schema}' AND INDEX_NAME != 'PRIMARY';

列出所有自動增長的 PK

SELECT 
    *
FROM 
    INFORMATION_SCHEMA.COLUMNS
WHERE 
    TABLE_SCHEMA = DATABASE()
    AND EXTRA LIKE '%auto_increment%';

參考:

• 封面圖來源: ghibli.jp