在数据表employee中根据id删除员工信息，下列@Delete注解的写法正确的是（）。
A: @Delete("delete from employee where id = ?")
B: @Delete("delete from employee")
C: @Delete( delete from employee where id =
D: {id} )
E: 以上说法都不正确
A: @Delete("delete from employee where id = ?")
B: @Delete("delete from employee")
C: @Delete( delete from employee where id =
D: {id} )
E: 以上说法都不正确
举一反三
- 删除student表中id为1的记录，下列语句正确的是 A: DELETE student WHERE id=1; B: DELETE FROM student WHERE id=1; C: DELETE FROM student WHERE id:=1; D: DELETE student WHERE id:=1;
- 下列关于删除表中记录的SQL语句,正确的是( )。 A: DELETE student,where id=11; B: DELETE FROM student where id=11; C: DELETE INTO student where id=11; D: DELETE student where id=11;
- 删除demo表中id为1001的记录。其SQL语句为（ ）。 A: delete from demo where id=1001 B: delete demo C: delete from dmeo where id=1001 D: delete demo where id=1001
- 删除student表中id为1的记录（） A: TRUNCATE FROM student where id=1; B: DELETE student where id=1; C: DELETE FROM student where id=1; D: DELETE INTO student where id=1;
- 删除表teacher(id,name,gender,birthday,score)中id为4的老师( ) A: delete from teacher; B: delete from teacher where id = 4; C: delete teacher where id = 4; D: drop from teacher where id = 4;