Database操作#DELETE編

DELETE文

DELETEはcrudのDeleteにあたるもの

基本

使用方法

DELETE FROM table_name;

WHEREで条件指定できる

---

table:user

name	age	gender	address
john	23	male	Tokyo
james	15	male	Osaka
robert	20	male	Tokyo
michael	32	male	Fukuoka
william	18	male	Tokyo

addressがTokyoの人を削除

DELETE FROM user WHERE address = 'Tokyo';

ageが20未満の人を削除

DELETE FROM user WHERE age < 20;

nameがjから始まる人を削除

DELETE FROM user WHERE name LIKE 'j%';