二级mysql哪里作答_计算机二级MySQL模拟题(附答案) - 副本

参考答案：DACCC CDBAD

参考答案：ACABB BCABB

参考答案：AAACB DCBCA

参考答案：DBCCD CCBCB

参考答案：BCCCD CDACD

参考答案：CBBCB ABCDC

代码答案：(如下)

1)

create database student

use student

create table student_web

(

s_id int not null,

s_name varchar(12),

s_fenshu int,

s_hometown varchar(50),

s_tuition int

)

2)

insert into student_web

(s_id,s_name,s_fenshu,s_hometown,s_tuition) values(1,’Jacktomas’,89,’北京丰台’,2800)

insert into student_web

(s_id,s_name,s_fenshu,s_hometown,s_tuition)

values(1,’TomJoe’,88,’天津南开’,3000)

insert into student_web

(s_id,s_name,s_fenshu,s_hometown,s_tuition)

values(1,’Smiths’,87,’北京海滨’,2700)

3)

select * from student_web

4)

select * from student_web where s_name like ’%J%’

5)

select * from student_web where s_hometown=’北京%’

6)

select * from student_web where s_tuition