mysql> select * from hero;
+------+--------+-----------------+
| h_id | h_name | h_skill         |
+------+--------+-----------------+
|    1 | 韩信   | 真裂天爆斩      |
+------+--------+-----------------+
1 row in set (0.00 sec)

delete from 表名 where 条件

mysql> delete from hero where h_id=1;
Query OK, 1 row affected (0.01 sec)

mysql> select * from hero;
Empty set (0.00 sec)

alter table hero add isdelete bit default 0;
在需要做逻辑删除的时候写上
update hero set isdelete=1 where h_id=5;