MySQL Forums
Forum List  »  Stored Procedures

Auto_Increment
Posted by: Harikrishna Guggilla
Date: February 04, 2020 12:43AM

getting the next auto_increment value in MySQL 5.7 version(windows) is working fine, But same is not working in MySQL 8.0.18 version. With the below query

Any leads on same, Please let me know

SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_NAME ='mytable' AND TABLE_SCHEMA='mydb';

Options: ReplyQuote


Subject
Views
Written By
Posted
Auto_Increment
318
February 04, 2020 12:43AM
141
February 04, 2020 09:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.