mysql查看表里面的auto increment 当前的数值是几
show create table test;
'test', 'CREATE TABLE `test` (\n `id` int NOT NULL AUTO_INCREMENT,\n `info` varchar(45) DEFAULT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3'
show create table test;
'test', 'CREATE TABLE `test` (\n `id` int NOT NULL AUTO_INCREMENT,\n `info` varchar(45) DEFAULT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3'