JWan Wiki

This is an old revision of the document!

---

SELECT 
    TABLE_SCHEMA as database_name,
    TABLE_NAME,
    COLUMN_NAME,
    DATA_TYPE,
    EXTRA
FROM information_schema.COLUMNS 
WHERE TABLE_SCHEMA IN ('databasename')
AND EXTRA LIKE '%auto_increment%'
ORDER BY TABLE_SCHEMA, TABLE_NAME;

change the databasename