mysql> select * from book; +------+--------+--------+ | num  | name   | office | +------+--------+--------+ |    1 | 길동홍 | 현대   | |    2 | 임꺽정 | 삼성   | +------+--------+--------+ 2 rows in set (0.00 sec) mysql> delete from book where name='임꺽정'; Query OK, 1 row affected (0.00 sec) mysql> select * from book    -> ; +------+--------+--------+ | num  | name   | office | +------+--------+--------+ |    1 | 길동홍 | 현대   | +------+--------+--------+ 1 row in set (0.01 sec)