1 格式
1 select auto_increment from information_schema.tables where table_schema='数据库名' and table_name='表名';
2 示例
1 select auto_increment from information_schema.tables where table_schema='bookstore' and table_name='book';
zhibiweilai 2020-07-01 15:09 原文
1 select auto_increment from information_schema.tables where table_schema='数据库名' and table_name='表名';
1 select auto_increment from information_schema.tables where table_schema='bookstore' and table_name='book';