MYSQL数据库基本操作一分钟学会！！！

数据插入

insert into student values(该表的元素),(),()；

数据更新

updata student set name=' ';  # 里面的内容将替换所有的name

数据的删除

delete from student;

数据的查询分组

select gender,min(age),avg(age) from student group by gender;

数据综合

select age,count(*) from student where age>20 group by age
order by age asc limit 3;   - asc 升序  desc 降序