---
# System prepended metadata

title: Untitled

---

```sql=
-- TABLE
CREATE TABLE `test` (
  `uid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

-- SCHEDULER
CREATE EVENT myevent1
	ON SCHEDULE EVERY  1 MINUTE
    DO
		INSERT INTO test(name) VALUES ('김'); 
        
CREATE EVENT myevent2
	ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 5 MINUTE
    DO 
		DELETE FROM test;
        
CREATE EVENT myevent3
	ON SCHEDULE EVERY 1 DAY STARTS '2022-12-29 13:30:00' ENDS '2022-12-31 13:30:00'
    DO 
		INSERT INTO test(name) VALUES ('이'); 
```