一、创建数据库: create database myschool;二、创建表： create table stuInfo( stu_no int(4) not null primary key auto_increment, stu_name varchar(10), stu_sex varchar(1) not null default '1', stu_age int(4) not null, stu_adr varchar(50));
create table score( sc_id int(4) not null primary key auto_increment, stu_no int(4) not null, sc_course varchar(4) not null, sc_score double(4,2) not null);三、插入数据：四、查询： select sc_score from stuInfo,score where stuInfo.stu_no=score.stu_no and stuInfo.stu_name='张三'; select stuinfo.stu_name,sc_score from stuinfo,score where stuInfo.stu_no=score.stu_no order by sc_score desc limit 3; select * from stuInfo where stu_no not in(select stu_no from score); select stuinfo.stu_name,avg(sc_score) from stuinfo,score where stuInfo.stu_no=score.stu_no group by stuinfo.stu_name; select dayofweek( date_add(now(),interval 2 year))-1;
