JWan Wiki

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

To get those with timestamp, can also be:

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 '%timestamp%'                 // or AND DATA_TYPE like '%timestamp%'
ORDER BY TABLE_SCHEMA, TABLE_NAME;