• 2022-07-23
    表的创建命令:create table test( id int auto_increment primary key, name varchar(10) not null, password varchar(32) not null);如果在表中插入一条记录,语法正确的是:
    A: insert into test value(0,'张三',md5('123456'));
    B: insert into test values(0,张三,md5(123456));
    C: insert into test value('张三',md5('123456'));
    D: insert into test values('张三',md5('123456'));
  • A

    举一反三

    内容

    • 0

      向学生表插入一条记录的正确命令是 A: APPEND INTO学生VALUES(“10359999”,'张三','男','会计',{^1983-10-28}) B: INSERT INTO学生VALUES(“10359999”,'张三','男',{^1983-10-28},'会计') C: APPEND INTO学生VALUES(“10359999”,'张三','男',{^1983-10-28},'会计') D: INSERT INTO学生VALUES(“10359999”,'张三','男',{^1983-10-28})

    • 1

      向学生表插入一条记录的正确命令是( )。 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)

    • 2

      智慧职教: 执行完下面的SQL语句,goods表中有几条记录?DROP TABLE IF EXISTS sCarInfo;CREATE TABLE sCarInfo(gdID INT ,uID INT,scNum INT,PRIMARY KEY(gdID,uID)) CHARSET utf8;INSERT INTO sCarInfo VALUES(1,1,2);INSERT INTO sCarInfo VALUES(1,1,3);INSERT INTO sCarInfo VALUES(2,1,2);INSERT INTO sCarInfo VALUES(1,2,2);INSERT INTO sCarInfo VALUES(1,null,2);INSERT INTO sCarInfo VALUES(null,1,2);

    • 3

      为表TEST中ID列添加主键约束的语法是() A: ALTER  TABLE  TEST  CHANGE( ID  INT  PRIMARY  KEY) B: ALTER  TABLE  TEST  ADD( ID  INT  PRIMARY  KEY) C: ALTER  TABLE  TEST  MODIFY( ID  INT  PRIMARY  KEY) D: ALTER  TABLE  TEST  ADD  CONSTRAINT PK  PRIMARY KEY (ID)

    • 4

      hive里创建表test,表里添加两个字段id和name,以下哪个HQL是正确的( ) A: create test(id int, name string); B: create test(int id, string name); C: create table test(int id, string name); D: create table test(id int, name string)