如下表格:
通过sql实现编号自动增加,序号也是自动增加,一个编号下有20个序号,id是主键
尝试使用触发器
create trigger my_trigger
before insert on test.test
for each row
begin
set new.`编号`=(select if(`序号`=20,`编号`+1,`编号`) as `编号` from test.test where id=(select max(id) from test.test));
set new.`序号`=(select if(`序号`=20,1,`序号`+1) as `序号` from test.test where id=(select max(id) from test.test));
end