5.mysql 基础之排序和分页
数据准备:创建表
create table emploees ( id int, name varchar(20), gender varchar(100), saraly double(10,2), department_id int, manger_man varchar(10) )
数据准备 :插入数据
insert into emploees values(101,'tom','m',5000,20,'zhangsan'); insert into emploees values(102,'tom1','m',6000,30,'zhangsan'); insert into emploees values(103,'tom2','m',7000,40,'zhangsan'); insert into emploees values(104,'tom3','m',8000,50,'zhangsan'); insert into emploees values(105,'tom4','m',9000,60,'zhangsan');
共有 0 条评论