1. function description
- The 'CreateTime' field in the original alarm table is the alarm record creation time. After modification, the value of the 'CreateTime' field is updated to the operation time whenever the alarm record is updated.
- Use tool: Navicat for MySQL
2. operating instructions
- 1 . Modify the "Proc_CreateAlarmMonthTable" function
- As shown in the figure, modify the stored procedure to 'CreateTime' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- Add 'ON UPDATE CURRENT_TIMESTAMP 'to the original statement'
-
After saving, the alarm month table created subsequently takes effect.
-
2 . Modify the alarm table for the current month and the next month (already created)
-
Right- click to open the "Design Table", select the 'CreateTime' field, check "Update Based on Current Timestamp", and click Save.
