create table emp(idint primary key auto_increment,
name varchar(20)not null,
sex enum('male','female')not null default 'male',#大部分是男的
age int(3) unsigned not null default 28,
hire_date date not null,
post varchar(50),
post_comment varchar(100),
salary double(15,2),
office int,#一个部门在同一个办公室
depart_id int);#插入记录#三个部门:教学,销售,运营
insert into emp(name,sex,age,hire_date,post,salary,office,depart_id) values
('mary','female',18,'20170301','teacher',7300.33,401,1),#以下是教学部('tom','male',78,'20150302','teacher',1000000.31,401,1),('kevin','male',81,'20130305','teacher',8300,401,1),('tony','male',73,'20140701','teacher',3500,401,1),('owen','male',28,'20121101','teacher',2100,401,1),('jack','female',18,'20110211','teacher',9000,401,1),('jenny','male',18,'19000301','teacher',30000,401,1),('sank','male',48,'20101111'
文章目录查询关键字表准备简单SQL语句解析查询关键字之where查询关键字之group by分组聚合函数查询关键字之having过滤查询关键字之distinct去重查询关键字之order by排序查询关键字之limit分页查询关键字之regexp正则多表查询查询思想前期表准备子查询连表操作查询关键字表准备create table emp( id int primary key auto_increment, name varchar(20) not null, sex enum('male