删除经销商1001的数据记录的代码为 _____ from distributors where distri_num=1001。
举一反三
- 删除经销商1018的数据记录的代码为( ) from distributors where distri_num=1018 A.drop table B.delete * C.drop column D.delete
- 删除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
- 从学生表中删除学号为“1001”的学生记录,正确的SQL语句是______。 A: DELETE FROM 学生 WHERE 学号="1001" B: DROP FROM 学生 FOR 学号="1001" C: DROP FROM 学生 WHERE 学号="1001" D: DELETE FROM 学生 FOR 学号="1001"
- 从学生表中删除学号为“1001”的学生记录,正确的SQL语句是______。 A: DROP FROM Student WHERE 学号="1001" B: DROP FROM Student FOR 学号="1001" C: DELETE FROM Student WHERE 学号="1001" D: DELETE FROM Student FOR 学号="1001"
- 从订单表中删除客户号为“1001“的订单记录,正确的SQL语句是()。 A: DROP FROM 订单 WHERE 客户号='1001' B: DROP FROM 订单 FOR 客户号='1001' C: DELETE FROM 订单 WHERE 客户号='1001' D: DELETE FROM 订单FOR 客户号='1001'