0 插入数据

people.sql ```sql create table people( id int primary key auto_increment, name varchar(10), age int, height decimal(5,2), gender enum(“男”, “女”, “中性”, “保密”) default “保密”, cls_id int, is_deleted tinyint(1) default 0 );

insert people values (1, “小明”, 18, 180, “女”, 1, 0), (2, “小月月”, 18, 180, “女”, 2, 0), (3, “彭于晏”, 29, 185, “男”, 1, 0), (4, “刘德华”, 59, 175, “男”, 2, 0), (5, “黄蓉”, 38, 160, “女”, 1, 0), (6, “凤姐”, 28, 150, “保密”, 2, 0), (7, “王祖贤”, 53, 172, “女”, 1, 0), (8, “周杰伦”, 36, null, “男”, 1, 0), (9, “程坤”, 27, 181, “男”, 2, 0), (10, “刘亦菲”, 25, 166, “女”, 1, 0), (11, “金星”, 33, 162, “中性”, 3, 0), (12, “静香”, 12, 150, “女”, 4, 0), (13, “郭靖”, 12, 170, “男”, 4, 0), (14, “周杰”, 34, 181, “男”, 5, 0);


- class.sql
```sql
create table class(
id int primary key auto_increment,
name varchar(4)
);
insert class values
(1, "A班"), 
(2, "B班"), 
(3, "C班");

1 条件查询

select * from people where age >18 and age <40;

2 模糊查询

(1) like匹配

_ 相当于一个任意字符
% 相当于0个或多个任意字符

select * from people where name like "小%";

select * from people where name like "__";

select * from user where zone == ‘086’ && mobile like “%6858”;