要显示表student的表结构,可以使用命令______。
A、STRUCTURE student;
B、DESCRIBE student;
C、SHOW CREATE TABLE student;
D、VIEW student;
A、STRUCTURE student;
B、DESCRIBE student;
C、SHOW CREATE TABLE student;
D、VIEW student;
A、9,9
B、9,10
C、10,10
D、10,9
createviewview1asselect*fromstudentwherestatus=0go执行下面两条命令的结果是()。updatestudentsetstatus=1wherestatus=0select*fromview1;
A.错误提示:不能对视图执行更新操作
B.错误提示:不能对视图执行查询操作
C.返回10条记录
D.返回0条记录
A、INSERT INTO students VALUES(1,'李刚’,’1999-01-01', 80)
B、INSERT INT0 students(sID,sName,birthday)VALUES(1,’李刚’,’1999-01-01',80)
C、INSERT INTO students VALUES (1,李刚,1999-01-01,80)
D、 INSERT INT0 students(sID, sName, birthday)VALUES(NULL,’李刚’,‘1999-01-01')
B、select sum(*) from student_tb where sex = '男';
C、select avg(*) from student_tb where sex = '男';
D、select max(*) from student_tb where sex = '男';
A、update students set Grade=Grade+10 where SID=1
B、update * set Grade=Grade+10
C、update * from stedents set Grade=Grade+10
D、update students set Grade=Grade+10
create table UserInfo(id int primary key auto_ _increment not null,name varchar (20) not nul1,age int default 20 not null);
A、insert into UserInfo values (nul1,‘admin’,22)
B、insert into UserInfo values (null,‘admin’,default)
C、insert into UserInfo (name) values (null,‘admin')
D、insert into UserInfo values(’admin’ ,25)
create table UserInfo (id int primary key auto_ increment not null,
name varchar(20) not null,age int default 20 not null);
A、insert into UserInfo values (nul1,‘admin’,22)
B、insert into User Info (name, age) values(‘admin’,default)
C、insert into User Info (age, name) values(‘admin’,20)
D、insert into UserInfo values (null,'admin’,25)
A.b.cno
B.b.sno
C.SELECTasno,sname,cno,cjFROMscaCROSSJOINcoursesbONa.cno
D.SELECTa.sno,sname,cno,cjFROMstudentsaJOINscbONa.sno
E.SELECTa.sno,sname,cno,cjFROMstudentsaCROSSJOINscbONa.sno
F.SELECTa.sno,sname,cno,cjFROMscaJOINsoursesbONa.cno
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!