![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL
文章平均质量分 59
儒冠多误身
What hurts more,The Pain of Hard Work or The Pain of Regret?
展开
-
MySQL求每个用户当月是否消费过
SELECT userId,DATE_FORMAT(paidTime,"%Y%m-01") from learn.order_info_utf GROUP BY userId,DATE_FORMAT(paidTime,"%Y%m-01") 使用left join SELECT t1.m,count(t1.m),count(t2.m) FROM ( SELECT userId,DATE_FO...原创 2018-12-01 16:26:34 · 560 阅读 · 0 评论 -
【儒冠多误身】MySQL个人学习笔记
文章目录MySQL个人学习笔记问题总结1. 报错2. 设置字符集3. 跳出执行入门语句增删改查创建表查看表结构增 insert改 update set where删 delete from where查 select查询模型建表数值型整型int系列的参数:(M) unsigned zerofill浮点型:float(M,D),会有损精度定点数:decimal(M,D)字符串型Char(M)定长字...原创 2018-11-28 15:08:31 · 383 阅读 · 0 评论