必知必会mysql学习.zip

# mysql 必知必会学习 ## day1 - [基础查询](https://github.com/vnues/mysql/blob/master/code/day1/基础查询.sql) - [条件查询](https://github.com/vnues/mysql/blob/master/code/day1/条件查询.sql) ## day2 - [常见函数](https://github.com/vnues/mysql/blob/master/code/day2/常见函数.sql) - [分组函数](https://github.com/vnues/mysql/blob/master/code/day2/分组函数.sql) - [分组查询](https://github.com/vnues/mysql/blob/master/code/day2/分组查询.sql) - [排序查询](https://github.com/vnues/mysql/blob/master/code/day2/排序查询.sql) - [连接查询](https://github.com/vnues/mysql/blob/master/code/day2/连接查询.sql) ## day3 - [分页查询](https://github.com/vnues/mysql/blob/master/code/day3/分页查询.sql) - [子查询](https://github.com/vnues/mysql/blob/master/code/day3/子查询.sql) ## day4 - [子查询案例](https://github.com/vnues/mysql/blob/master/code/day4/子查询案例.sql) - [库和表的管理](https://github.com/vnues/mysql/blob/master/code/day4/库和表的管理.sql) - [数据的增删改](https://github.com/vnues/mysql/blob/master/code/day4/数据的增删改.sql) - [数据类型](https://github.com/vnues/mysql/blob/master/code/day4/数据类型.sql) - [联表查询](https://github.com/vnues/mysql/blob/master/code/day4/联合查询.sql) ## day5 - [事务](https://github.com/vnues/mysql/blob/master/code/day5/事务.sql) - [常见约束](https://github.com/vnues/mysql/blob/master/code/day5/常见约束.sql) - [标识列](https://github.com/vnues/mysql/blob/master/code/day5/标识列.sql) - [视图](https://github.com/vnues/mysql/blob/master/code/day5/视图.sql) ## day6 - [函数](https://github.com/vnues/mysql/blob/master/code/day6/函数.sql) - [变量](https://github.com/vnues/mysql/blob/master/code/day6/变量.sql) - [存储过程](https://github.com/vnues/mysql/blob/master/code/day6/存储过程.sql) - [流程控制经典案例讲解](https://github.com/vnues/mysql/blob/master/code/day6/流程控制经典案例讲解.sql) - [流程控制结构](https://github.com/vnues/mysql/blob/master/code/day6/流程控制结构.sql) ## 杂七杂八 - [note](https://github.com/vnues/mysql/blob/master/note.sql)