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})
举一反三
- 向学生表插入一条记录的正确命令是( )。 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)
- 向学生表student_info插入一条记录的正确的SQL语句是( ) A: APPEND INTO student_infoVALUES('10359999','张三','男','会计','1983-10-28') B: insert into student_info VALUES('10359999','张三','男','1983-10-28','会计') C: update into student_info VALUES('10359999','张三','男','1983-10-28','会计') D: delete from student_info VALUES('10359999','张三','男','1983-10-28','会计')
- 若有“学生”表,其关系模式为:学生(学号,姓名,性别,出生日期),下列哪些语句可以实现向“学生”表插入两条记录的功能? A: INSERT INTO 学生 VALUES ('001','刘梅','女','1997-10-18') ('002','赵刚','男','1998-11-20') B: INSERT INTO 学生 VALUES ('001','刘梅','女','1997-10-18'),('002','赵刚','男','1998-11-20') C: INSERT INTO 学生 VALUES ('001','刘梅','女'),('002','赵刚','男') D: INSERT INTO 学生(学号,姓名,性别) VALUES ('001','刘梅','女'),('002','赵刚','男')
- 表的创建命令: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'));
- 下列选项中,能够一次给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, '王五');
内容
- 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)