DROP TRIGGER IF EXISTS chufa;CREATE DEFINER=root@localhost TRIGGER chufa AFTER INSERT ON db_product FOR EACH ROW INSERT INTO db_change (value, theme) VALUES (concat('/path/',product_id),theme_value)
When a new record is generated in db_product, merge the string /path/ with the product_id in the db_product table, and insert it together with theme_value into the value and theme fields of db_change
I don’t know what the error is, but it doesn’t work. consult
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Tell me where theme_value comes from, and the syntax of new or old before product_id is not written