How to add field father to dede_sys_enum by dede

This article will explain in detail how dede adds the field father to dede_sys_enum. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

How does dede add the field father to dede_sys_enum?

Dede provides a linkage model, corresponding to the database table dede_sys_enum, adding a parent node field. Provides automatic trigger updates.

Things:

Dede provides a linkage model, corresponding to the database table dede_sys_enum, adding a parent node field. Provides automatic trigger updates.

Resolve:

The trigger modifies the value of the father field

The code is as follows:

DELIMITER $$CREATE TRIGGER `dede_sys_enum_ AINS` BEFORE INSERT ON dede_sys_enum FOR EACH ROW BEGIN SET new.father=REPLACE (new.evalue,new.evalue,FLOOR (new.evalue/500) * 500). End has shared here on how to add fields father to dede_sys_enum by dede. I hope the above content can help you and learn more. If you think the article is good, you can share it for more people to see.