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'));
举一反三
- 下列选项中,采用指定表的所有字段名的方式给test表插入“id”为“1”,“name”为“小王” 的记录,正确语句是( )。 A: INSERT INTO test(“id”,”name”) VALUES(1,"小王"); B: INSERT INTO test VALUE(1,"小王"); C: INSERT INTO test VALUES(1, '小王'); D: INSERT INTO test(id,name)VALUES(1, '小王');
- 下列选项中,能够一次给user表插入三条记录的SQL 语句是( )。 A: INSERT INTO user VALUES( 5,'张三');(6,'李四');(7, '王五'); B: INSERT INTO user VALUES( 5,'张三')(6,'李四')(7, '王五'); C: INSERT INTO user VALUES( 5,'张三'),(6,'李四'),(7, '王五'); D: INSERT INTO test VALUES( 5,'张三')VALUES(6,'李四')VALUES(7, '王五');
- 现有用户信息表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','张三');
- 表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,“张三”)
- 用一条SQL语句查询出每门课都大于80分的学生姓名 准备数据的sql代码: create table score(id int primary key auto_increment, name varchar(20),sub ject varchar(20), score int); insert into score values (null,'张三','语文',81), (null,'张三','数学',75), (null,'李四','语文',76), (null,'李四','数学',90),(null,'王 五','语文',81), (null,'王五','数学',100), (null,'王五 ','英语',90);
内容
- 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)