DELIMITER $$
CREATE TRIGGER TRIGGER_NAME
BEFORE INSERT ON TABLE_NAME FOR EACH ROW
BEGIN
SET NEW.ORD = (SELECT MAX(COLUNM_NAME)+1 FROM TABLE_NAME WHERE CONDITIONS);
END $$
DELIMITER ;
CREATE TRIGGER TRIGGER_NAME
BEFORE INSERT ON TABLE_NAME FOR EACH ROW
BEGIN
SET NEW.ORD = (SELECT MAX(COLUNM_NAME)+1 FROM TABLE_NAME WHERE CONDITIONS);
END $$
DELIMITER ;
扫一扫
219
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
