CREATE TRIGGER `updateNameOninsert` BEFORE INSERT ON `temp` FOR EACH ROW
begin
set @aa=0;
select max(0+name) into @aa from temp;
set new.name=Lpad(1+@aa,6,'0');
end
CREATE TRIGGER `updateNameOninsert` BEFORE INSERT ON `temp` FOR EACH ROW
begin
set @aa=0;
select max(0+name) into @aa from temp;
set new.name=Lpad(1+@aa,6,'0');
end