Get current AUTO_INCREMENT value for any table

by

You can get all of the table data by using this query:

SHOW TABLE STATUS FROM `DatabaseName` WHERE `name` LIKE 'TableName' ;

You can get exactly this information by using this query:

SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'DatabaseName'
AND   TABLE_NAME   = 'TableName';

More Related Contents:

  1. How to reset AUTO_INCREMENT in MySQL
  2. How to make MySQL table primary key auto increment with some prefix
  3. How to set initial value and auto increment in MySQL?
  4. Get the new record primary key ID from MySQL insert query?
  5. MySQL AUTO_INCREMENT does not ROLLBACK
  6. SQL: Creating a Relational table with 2 different auto_increment
  7. How to handle fragmentation of auto_increment ID column in MySQL
  8. Prevent auto increment on MySQL duplicate insert
  9. Add Auto-Increment ID to existing table?
  10. How to fill in the “holes” in auto-increment fields?
  11. How to insert data to MySQL with auto-incremented column(field)?
  12. MySQL: #1075 – Incorrect table definition; autoincrement vs another key?
  13. auto_increment by group
  14. How does MySQL Auto Increment work?
  15. Why does MySQL autoincrement increase on failed inserts?
  16. How to force MySQL to take 0 as a valid auto-increment value
  17. Defining Composite Key with Auto Increment in MySQL
  18. mysql Failed to read auto-increment value from storage engine
  19. Too many auto increments with ON DUPLICATE KEY UPDATE
  20. How to reuse auto_increment values? [duplicate]
  21. make an ID in a mysql table auto_increment (after the fact)
  22. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  23. MySQL Conditional Insert
  24. How to properly create composite primary keys – MYSQL
  25. How to change the foreign key referential action? (behavior)
  26. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  27. MySQL Pivot Table Column Data as Rows
  28. How repair corrupt xampp ‘mysql.user’ table?
  29. What is the MySQL query equivalent of PHP strip_tags?
  30. MySQL errorno 121

Leave a Comment