56,937
社区成员




insert into a values(0,0,'3'),(0,0,'4');
CREATE TABLE `a` (
`aa` int(11) NOT NULL AUTO_INCREMENT,
`bb` int(11) NOT NULL,
`cc` varchar(20) DEFAULT NULL,
PRIMARY KEY (`aa`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
drop trigger if exists trig1;
CREATE DEFINER=`cpc`@`localhost` TRIGGER `test`.`trig1` BEFORE INSERT ON test.a FOR EACH ROW
BEGIN
set new.bb=(select if(isnull(aa),1,aa+1) from (select max(aa) as aa from a) tmp);
END;
insert into a (
aa
,bb
,cc
) VALUES (
0 -- aa
,0 -- bb
,'1' -- cc
)
select * from a;