Retrieve MAX Primary Key values of all tables in a database at once

Question

What I need to do is retrieve the maximum primary key of all tables in my database at once? That is, my result will be like if I executed the below 2 queries:

SHOW TABLES FROM DATABASE_NAME

SELECT MAX(PRIMARY_KEY) AS maxId FROM TABLE

That is

(first column = TableName , second column = MAX(PK) Of that table)

Pardon if I am doing something wrong. I just do not want to write 80 queries because my database has 80 tables.

Answer 1

If (and only if) your primary keys are AUTO INCREMENT variables you can do this:

SELECT TABLE_NAME, AUTO_INCREMENT
FROM   information_schema.TABLES
WHERE  TABLE_SCHEMA = 'mydb'