删除表Teacher中编号为070041的记录，应为（）
A: ADELETE FROM Teacher WHERE编号="070041"
B: BDELETE FROM Teacher 编号="070041"
C: CDELETE编号="070041"FROMTeacher
D: DDELETE FROM Teacher WHERE编号IS"070041"
A: ADELETE FROM Teacher WHERE编号="070041"
B: BDELETE FROM Teacher 编号="070041"
C: CDELETE编号="070041"FROMTeacher
D: DDELETE FROM Teacher WHERE编号IS"070041"
举一反三
- 删除表Teacher中编号为070041的记录，应为（） A: DELETEFROMTeacherWHERE编号="070041" B: DELETEFROMTeacher编号="070041" C: DELETE编号="070041"FROMTeacher D: DELETEFROMTeacherWHERE编号IS"070041"
- 删除表Teacher中编号为070041的记录，应为（）
- 在“课程表”中删除课程编号为J001的记录，使用SQL命令( )。 A: INSERT FROM 课程表 WHERE 课程编号='J001' B: DELETE FROM 课程表 WHERE 课程编号='J001' C: UPDATE FROM 课程表 WHERE 课程编号='J001' D: SELECT FROM 课程表 WHERE 课程编号='J001'
- 删除表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;
- 删除“课程”表中课程编号为“J001”的课程信息的SQL语句是( )。 A: DELETE FROM 课程 WHERE 课程编号=J001 B: DELETE FROM 课程 WHERE 课程编号=’J001’ C: SELECT * FROM 课程 WHERE 课程编号=’J001’ D: DELETE * FROM课程 WHERE 课程编号=J001