删除表course的记录。其SQL语句为（ ）。
A: DELETE from course where *
B: DELETE * from course
C: DELETE course
D: DELETE FROM course
A: DELETE from course where *
B: DELETE * from course
C: DELETE course
D: DELETE FROM course
举一反三
- 删除课程号为s5的课程记录，使用SQL语句：delete course cno="s5";
- 删除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
- 下列语句（）能够查询所有英语类课程的信息。 A: SELECT * FROM Course WHERE cname LIKE ‘%英语’ B: SELECT * FROM Course WHERE cname LIKE ‘%英语%’ C: SELECT * FROM Course WHERE cname LIKE ‘_英语_’ D: SELECT * FROM Course WHERE cname LIKE ‘*英语*’
- 以下（ ）SQL语句可以查询出课程名中只包含“_design”字符串的课程信息。 A: select * from course where cname like '%_design%' B: select * from course where cname like '%\_design%' escape '\' C: select * from course where cname like '% D: _design%' escape ' E: ' F: select * from course where cname like '%*_design%' escape '*'
- 删除student表中学号为101的记录。其SQL语句为（ ）。 A: DELETE stu where stu_no=101 B: DELETE studnets C: DELETE student WHERE stu_no=101 D: DELETE FROM student WHERE stu_no=101