[ mariadb query ] delete문

 

문법 

 

DELETE FROM [ 테이블 ] WHERE [ 조건 ]

---

샘플) 로그타임의 '2019-09-01 00:00:00' 에서 '2019-09-01 23:59:59' 조건의 데이터 삭제

 

delete
from weblog
where logtime between '2019-09-01 00:00:00' and '2019-09-01 23:59:29'