获取当前自增列 select auto_increment from information_schema.`TABLES` where table_name='t_product'; 更新自增列序号: ALTER TABLE `t_product` AUTO_INCREMENT=3;