函数
set global log_bin_trust_function_creators=1;
DELIMITER //
DROP function if exists incNum//
CREATE FUNCTION incNum() RETURNS int(11)
BEGIN
set @tem=1;
select card_number into @tem from `vip_card` order by card_number desc limit 1;
set @tem=@tem+1;
return @tem;
END
//
DELIMITER ;
select incNum();
触发器
CREATE TRIGGER incNum BEFORE INSERT ON vip_card
FOR EACH ROW BEGIN
set @tem=1;
select card_number into @tem from `vip_card` order by card_number desc limit 1;
set new.card_number=@tem+1;
end
本文转自 Lee_吉 博客,原文链接: http://blog.51cto.com/12173069/1969929 如需转载请自行联系原作者