검색어: MySQL delete syntax
https://dev.mysql.com/doc/refman/8.0/en/delete.html
MySQL :: MySQL 8.0 Reference Manual :: 13.2.2 DELETE Statement
MySQL 8.0 Reference Manual / ... / SQL Statements / Data Manipulation Statements / DELETE Statement DELETE is a DML statement that removes rows from a table. A DELETE statement can start with a WITH clause to define common table expressions
dev.mysql.com
WHERE 빠뜨리면 모든 행이 삭제된다.
DELETE FROM topic WHERE id = 2;
'MySQL > 생활코딩' 카테고리의 다른 글
| 생활코딩 - MySQL - 15. 관계형 DB의 필요성 (0) | 2020.06.08 |
|---|---|
| 생활코딩 - MySQL - 14. 수업의 정상 (0) | 2020.06.08 |
| 생활코딩 - MySQL - 12. UPDATE (0) | 2020.06.08 |
| 생활코딩 - MySQL - 11. SELECT (0) | 2020.06.08 |
| 생활코딩 - MySQL - 10. INSERT 구문 (0) | 2020.06.08 |
댓글