MYSQL,觸發器,實現多個表共用ID不重複

標籤：bsp   desc   row   pre   class   get   實現   nbsp   自動   

 

參考:https://my.oschina.net/jiuxiaoyao/blog/839266

MYSQL 沒有sequence 

SET @@auto_increment_offset
SET @@auto_increment_increment

也只能在當前查詢有效.所以這也是權宜之計

DROP TRIGGER IF EXISTS `InsertUser`;create trigger InsertUser    before insert on userinfo   for each row    Begin   declare id int;insert into user values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);#讓自動成長的表插入失敗,ID作廢,就可以讓觸發器的表使用select id  into @id from user order by id desc limit 1;set new.id = @id;end;  

 

MYSQL,觸發器,實現多個表共用ID不重複