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
内容
- 0
删除数据表teacher中教工号(num)为1002的记录删除,使用下列哪条SQL语句( ) A: DELETE FROM teacher num=1002; B: DELETE FROM teacher WHERE num=1002; C: DELETE FROM teacher ,num=1002; D: DELETE teacher where num=1002;
- 1
下列语句用来删除数据表中指定记录,正确的语句是( )。 A: DELETE FROM book WHERE 单价>20 B: DELETE * FROM book C: DELETE FROM book HAVING 单价>20 D: DELETE FROM book
- 2
若学生表中存储了学号、姓名、性别、成绩等字段,则“删除所有女学生记录”的SQL语句是__________。 A: DELETE FROM 学生 WHERE 性别=女 B: DELETE FROM 学生 WHERE 性别=“女” C: DELETE * FROM 学生 WHERE 性别=“女” D: DELETE * FROM 学生 WHERE 性别=“女%”
- 3
设“学生”表中有 “学号”等字段,删除学号为“S01002”的学生的记录,正确的SQL语句是( )。 A: DELETE 学号="S01002" B: DELETE FROM 学号="S01002" C: DELETE 学号="S01002" FROM 学生 D: DELETE FROM 学生 WHERE 学号="S01002"
- 4
下面SQL语句中,用于删除student表中age小于20的记录的语句是 A: DELETE student where age<20; B: DELETE FROM student where age<20; C: DELETE FROM student set age<20; D: DELETE studentset age<20;