• 2022-06-18
    对以下程序描述正确的是( )delete from user where id not in (2,3)
    A: 删除id为2和3的数据
    B: 删除id为2的数据
    C: 删除id为3的数据
    D: 删除id不是2或3的数据
  • D
    本题目来自[网课答案]本页地址:https://www.wkda.cn/ask/mjyayexemxtzooo.html

    内容

    • 0

      删除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;

    • 1

      删除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;

    • 2

      删除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

    • 3

      删除表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;

    • 4

      假设user表一共有5条数据,执行以下代码后剩下( )DELETE from user ORDER BY id LIMIT 3 A: 2 B: 3 C: 4 D: 5