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_吉  部落格，原文連結：   http://blog.51cto.com/12173069/1969929     如需轉載請自行聯系原作者