Shulou(Shulou.com)06/02 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.