できるPRO MySQL できるPROシリーズ Kindle版の内容をまとめる。
DELETE
DELETE FROM テーブル名 WHERE 条件
SELECT * FROM members;
MariaDB [dekirusample]> select * from members;
+-------+------------------+----------+
| memno | name | pref |
+-------+------------------+----------+
| 1 | たかはしまさかず | 神奈川県 |
| 2 | 山本陽一 | 北海道 |
| 3 | 杉本彰大 | 福岡県 |
| 4 | 石橋克隆 | NULL |
+-------+------------------+----------+
4 rows in set (0.00 sec)
DELETE FROM MEMBERS WHERE memno=1;
MariaDB [dekirusample]>DELETE FROM MEMBERS WHERE memno=1;
Query OK, 1 row affected (0.01 sec)
SELECT * FROM members;
MariaDB [dekirusample]> SELECT * FROM members;
+-------+----------+--------+
| memno | name | pref |
+-------+----------+--------+
| 2 | 山本陽一 | 北海道 |
| 3 | 杉本彰大 | 福岡県 |
| 4 | 石橋克隆 | NULL |
+-------+----------+--------+
3 rows in set (0.00 sec)