mysql使用基础

一、创建数据库: 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;