mysql用触发器自增值_mysql利用函数和触发器实现非主键自增-阿里云开发者社区...

函数

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_吉 51CTO博客，原文链接:http://blog.51cto.com/12173069/1969929