MySQL Forums
Forum List  »  General

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

Generating the next auto_increment values in MySQL 5.7.17(Windows) is working good, But same is not working in MySQL 8.0.18 version. With the following query

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

Any leads, Please let help me on this.

Options: ReplyQuote


Subject
Written By
Posted
Auto_Increment
February 04, 2020 12:49AM


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.