Auto_Increment
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';
Subject
Views
Written By
Posted
Auto_Increment
1038
February 04, 2020 12:43AM
335
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.