How to get the next auto-increment id in mysql

by

You can use 

SELECT AUTO_INCREMENT
FROM information_schema.tables
WHERE table_name="table_name"
AND table_schema = DATABASE( ) ;

or if you do not wish to use information_schema you can use this

SHOW TABLE STATUS LIKE 'table_name'

More Related Contents:

  1. how to delete data from table A besides the customer service and director data in table B?
  2. Error related to only_full_group_by when executing a query in MySql
  3. SQL split values to multiple rows
  4. Get records with max value for each group of grouped SQL results
  5. How to populate a table with a range of dates?
  6. MYSQL OR vs IN performance
  7. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  8. MySQL Cannot Add Foreign Key Constraint
  9. Grouping into interval of 5 minutes within a time range
  10. Convert timestamp to date in MySQL query
  11. Update a column value, replacing part of a string
  12. MySQL: View with Subquery in the FROM Clause Limitation
  13. MySQL/MariaDB – order by inside subquery
  14. View’s SELECT contains a subquery in the FROM clause
  15. Can MySQL replace multiple characters?
  16. OUTPUT Clause in MySQL
  17. Using ORDER BY and GROUP BY together
  18. Sorting by date & time in descending order?
  19. Difference between these two joining table approaches?
  20. MySQL Pivot Table Column Data as Rows
  21. updating columns with a sequence number mysql
  22. MySQL, Concatenate two columns
  23. Select a column with a keyword name
  24. MySQL Stored Procedures not working with SELECT (basic question)
  25. ERROR 1148: The used command is not allowed with this MySQL version
  26. Use Composite Primary Key as Foreign Key
  27. MySQL Select minimum/maximum among two (or more) given values
  28. MySQL OPTIMIZE all tables?
  29. Strip last two characters of a column in MySQL
  30. Deleting a row based on the max value

Leave a Comment