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: 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;
- 删除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;
- 从学生表中删除学号为“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"
内容
- 0
从订单表中删除客户号为“1001“的订单记录,正确的SQL语句是()。 A: DROP FROM 订单 WHERE 客户号='1001' B: DROP FROM 订单 FOR 客户号='1001' C: DELETE FROM 订单 WHERE 客户号='1001' D: DELETE FROM 订单FOR 客户号='1001'
- 1
已知企业员工管理数据库中员工表结构如下:员工(工号,姓名,性别,年龄,部门)。现要从该表删除一条工号为“1001”的员工记录,则删除语句应该是() A: delete from 员工 where 工号=1001 B: delete * from员工where工号=1001 C: delete员工where工号 is 1001 D: delete * from员工where工号 is 1001
- 2
删除表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;
- 3
下列各题使用如下表: Student.dbf(学号,姓名,课程号,成绩) 从学生表中删除学号为“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"
- 4
在数据表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: 以上说法都不正确