Question

我的MySQL数据库有一个内容表(一张数字内容表,其价值),该数据库有自动加固的初级钥匙。我想能够实施奇迹甚至id折的解决办法,因为生产内容甚至有焦炭,而生产内容却有奇迹,以避免在我玩.时爆发冲突。不幸的是,MySQL不支持顺序,也不支持自动加固值(即只为 d而不是1而加2)。

The best solution I can think of, is to have a BEFORE INSERT and AFTER INSERT trigger which sets the session value of auto_increment_increment to 2 in the BEFORE INSERT trigger, and then resets it to 1 in the AFTER INSERT trigger. Since it only sets the session variable, it shouldn t have any effect on other processes, and since it s a Drupal CMS table and nothing complicated is happening, it seems safe, even though it feels wrong.

然而,我说,我是一位中间的MySQL Admin(最好有:)和我说,我肯定会感到 ha笑,因此,我认为我会在这里提出这个问题,看任何人是否对此有强烈的消极反应,也许有些问题I m没有预见到。 (如果没有人这么做的话,我会认为其他人会这样做。)

Answer 1

Here s a simple example of what you want to do - assuming there is an integer column seq in the my_table_name table:

DROP trigger my_trigger_name;  

CREATE TRIGGER my_trigger_name
BEFORE INSERT ON my_table_name
FOR EACH ROW
SET NEW.seq = (select ifnull(max(seq)+1,1) from source_table_name);

友情链接