5.3.1 delete:操作 delete操作用于删除表中数据,其使用语法如下所示。 delete from表名 delete from指定从哪个表中删除数据。因为删除动作的 作用对象为记录级别,因此无需指定列名信息。 【示例5-6】我们可以利用delete命令删除表students中、 employee_id大于10的记录,相应的SQL语句如下所示。 SQL>delete from students where student id>10; 3 rows deleteddelete delete from delete from 5-6 delete students employee_id 10 SQL SQL> delete from students where student_id>10; 3 rows deleted