• 2022-06-07
    向学生表插入一条记录的正确命令是( )。
    A: A) APPEND INTO 学生 VALUES("10359999","张三","男","会计",^1983-10-28)
    B: B) INSERT INTO 学生 VALUES("10359999","张三","男",^1983-10-28,"会计")
    C: C) APPEND INTO 学生 VALUES("10359999","张三","男",^1983-10-28,"会计")
    D: D) INSERT INTO 学生 VALUES("10359999","张三","男",1983-10-28)
  • B

    举一反三

    内容

    • 0

      表student中的包含两个字段,整型的id,字符串型的name。向表student中插入一条记录的正确SQL语句( ) A: insert into student(2018001,“张三”) B: insert into student values(2018001,'张三') C: insert into student(2018001,'张三') D: insert into student values (2018001,“张三”)

    • 1

      现有用户信息表userinfo,表结构如下:id integer 主键,自增长;uname text 用户名;password text 密码。如果想添加用户名为张三,密码为123的用户,下面SQL语句正确的是() A: insert into userinfo(uname,password) values('张三','123'); B: insert into userinfo(uname,password) values(张三,123); C: insert into userinfo values(null,'张三','123'); D: insert into userinfo(password,uname) values('123','张三');

    • 2

      向商品表中插入一条记录的正确命令是______。 A: APPEND INTO 商品表 VALUES("00066","016","飞利浦彩电",5600,2) B: INSERT INTO 商品表 VALUES("00066","016","飞利浦彩电",5600,2) C: APPEND INTO 商品表 VALUES("00066","016","飞利浦彩电",5600,2) D: INSERT INTO 商品表 VALUES("00066","飞利浦彩电","016",5600,2)

    • 3

      向student表插入一条新记录的正确SQL语句是( )。 A: APPEND INTO student VALUES(′0401′,′王芳’,′女′,18) B: APPEND student VALUES(′0401′,′王芳′,′女′,18) C: INSERT INTO student VALUES(′0401′,′王芳′,′女′,18) D: INSERT student VALUES(′0401′,′王芳′,′女′,18)

    • 4

      向student表插入一条新记录的正确SQL语句是______。 A: INSERT INTO student VALUES("0401","丽萍","女",18) B: APPEND student VALUES("0401","丽萍","女",18) C: APPEND INTO student VALUES("0401","丽萍","女",18) D: INSERT student VALUES("0401","丽萍","女",18)