mysql学习工程中遇到的一些问题，希望对各位有帮助

日期函数year,month,day,time

https://www.cnblogs.com/dengyg200891/p/5966264.html

Case when语句

https://blog.csdn.net/qq_32534855/article/details/86688083?ops_request_misc=&request_id=&biz_id=102&utm_term=mysqlcasewhen%E8%AF%AD%E6%B3%95&utm_medium=distribute.pc_search_result.none-task-blog-2_allsobaiduweb~default-0-86688083.first_rank_v2_pc_rank_v29&spm=1018.2226.3001.4187

https://blog.csdn.net/qq_30038111/article/details/79611167?ops_request_misc=&request_id=&biz_id=102&utm_term=mysqlcasewhen%E8%AF%AD%E6%B3%95&utm_medium=distribute.pc_search_result.none-task-blog-2_allsobaiduweb~default-1-79611167.first_rank_v2_pc_rank_v29&spm=1018.2226.3001.4187

按年分组统计每个季度的销量

https://blog.csdn.net/qq_41456723/article/details/108682462

mysql按日、周、月、季度统计数据

https://blog.csdn.net/weixin_40333020/article/details/88574983

Mysql float类型where 语句判断相等问题

https://blog.csdn.net/ykm0722/article/details/7003754?ops_request_misc=&request_id=&biz_id=102&utm_term=mysql%E4%B8%AD%E6%AF%94%E8%BE%83float&utm_medium=distribute.pc_search_result.none-task-blog-2_allsobaiduweb~default-1-7003754.first_rank_v2_pc_rank_v29&spm=1018.2226.3001.4187

MYSQL 两个datetime类型相减

https://blog.csdn.net/cf643487053/article/details/53390464?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522160992697216780274071026%2522%252C%2522scm%2522%253A%252220140713.130102334…%2522%257D&request_id=160992697216780274071026&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2_allbaidu_landing_v2~default-1-53390464.first_rank_v2_pc_rank_v29&utm_term=mysql%20datatime%E5%81%9A%E5%B7%AE&spm=1018.2226.3001.4187

mysql 合并 多个无关联的表 的数据 到一个视图（笛卡尔连接）

https://blog.csdn.net/shunchang/article/details/108270345?ops_request_misc=%25257B%252522request%25255Fid%252522%25253A%252522160999332716780273663518%252522%25252C%252522scm%252522%25253A%25252220140713.130102334…%252522%25257D&request_id=160999332716780273663518&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2_allsobaiduend~default-1-108270345.first_rank_v2_pc_rank_v29&utm_term=mysql%20cross%20join