MYSQL, triggers, implementing multiple tables common ID not duplicated

Reference: https://my.oschina.net/jiuxiaoyao/blog/839266

MYSQL No sequence

SET @ @auto_increment_offset
SET @ @auto_increment_increment

It can only be valid in the current query. So this is a stopgap.

DROP TRIGGER IF EXISTS' Insertuser ';Create TriggerInsertuser beforeInsert  onUserInfo forEach rowBegin   DeclareIdint;Insert  into User Values(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL#让自动增长的表插入失败, the ID is obsolete, you can make the trigger table useSelectId into @id  from User Order  byIddescLimit1;SetNew.id= @id;End;

MYSQL, triggers, implementing multiple tables common ID not duplicated