通过查询information_schema.tables表获取值
获取下一条自增值(ID):SELECT auto_increment FROM information_schema.tables WHERE table_name='表名'
获取当前自增值(ID):SELECT (auto_increment-1) FROM information_schema.tables WHERE table_name='表名'
通过查询information_schema.tables表获取值
获取下一条自增值(ID):SELECT auto_increment FROM information_schema.tables WHERE table_name='表名'
获取当前自增值(ID):SELECT (auto_increment-1) FROM information_schema.tables WHERE table_name='表名'