找到空缺的 id select a.id+1 as id, b.id as bid from pindao a left join pindao b on a.id+1=b.id where b.id is null limit 1指定 id 插入 INSERT INTO `pindao` (`id`, `type`, `name`, `alias`, `sort`, `disabled`, `thumb`, `banner`, `description`, `author`) VALUES ($id, 'goods', '情侣装罗弯弯', 'qinglvzhuangluowanwan', 0, 0, '', '', '', ''),
select a.id+1 as id, b.id as bid from pindao a left join pindao b on a.id+1=b.id where b.id is null limit 1指定 id 插入
INSERT INTO `pindao` (`id`, `type`, `name`, `alias`, `sort`, `disabled`, `thumb`, `banner`, `description`, `author`) VALUES ($id, 'goods', '情侣装罗弯弯', 'qinglvzhuangluowanwan', 0, 0, '', '', '', ''),