How does Navicat automatically and regularly clear the contents of a field in a table (only clears the content, not the field)?

Question

How does Navicat automatically and regularly clear the contents of a field in a table (only clears the content, not the field)? It is said on the Internet that it can be solved by defining events. Please give me a solution, preferably with code.

Answer 1

Since automatic clearing must involve scheduled tasks. You can write a PHP, and the logic is to clear the content of this field in the table. Save it as task.php and then use the scheduled task command of the Linux server to check the one-line command. The solution is to specify when to execute which file. Just set the timing period and specify the execution file of the command.

Answer 2

Your question is too general, and it doesn't say whether it is operated through a program or just executed in the software. Baidu has searched many solutions, you can refer to them.