Erstellen Sie ein Ereignis in MySQL, das eine Spalte einer Tabelle 2 Minuten nach dem Moment aktualisiert, in dem sie erstellt wird.
To create an event in MySQL that updates a column of a table that has passed 2 minutes from the moment it is created, you can follow the following steps: 1. Make sure that your MySQL version is supported by events. You can check it by running the following command: [sql] SHOW VARIBLES LIKE 'event_schedule'; If the value of the variable event_schedule is "ON", then your MySQL version is supported by events. If the value is "OFF", you can enable the events by running the following command: [vbnet] SET GLOBAL_schedule event_scheduler= ON; 2. Create a table containing the column that you want to update. For example: [sql] CREATE CREATE TABLE MY_tabla ( id INT PRIMARY KEY, column_a_upgrade VARCAR_BAR_BAR_BAR_255, date_create TIMEST TOM TOM TOM TOM UM QUI UM ); In this case, the two minutes we want to update the column that we want to update is column_a_a_a_NO KE KEY KEY, and save theThis can be checked by running the following command: [sql] SHOW PROCESSSLIST; If there is a process called "Daemon" or "Event Scheduler", then the event daemon is active. If not, you can start it by running the following command: [vbnet] SET GLOBAL GLOBAL event_scheduler = ON; I hope I was of help; I hope I was of help; I hope I was of help; I hope I was of help; I hope I was of help if I was of help if I had been of help help if I had been of help if I had been of help if I had been of help if I had been able to help: [vbnet] SET GLOBAL GLOBAL event_schedule_scheduler = ON; I hope I hope I was of help I was helpful; I hope I hope I hope I hope I was helpful to be of help I was helpful to help I was helpful I was helpful to help: [vbnet] SET SET GLOBAL GLOBAL GLOBAL GLOBAL GLOBAL to GL GLOBAL event event event event event event event event event event event event event event event event event event event event event event event event event event event event