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%';