求某个月有多少天 我是想求某个月有多少天select date_add(ms,-3,date_add(mm, DATEDIFF(m,0,GETDATE())+1,0))) 这句话哪里错了啊,我运行时总出错然后如何循环出每天啊? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 LZ写的是什么? "ms mm m"能这么写? getdate()你写的函数? 完全不知所云 mysql> select day(date_add(date_add(concat(date_format(now(),'%Y-%m'),'-01') ,interval 1 month),interval -1 day));+-----------------------------------------------------------------------------------------------------+| day(date_add(date_add(concat(date_format(now(),'%Y-%m'),'-01') ,interval 1 month),interval -1 day)) |+-----------------------------------------------------------------------------------------------------+| 31 |+-----------------------------------------------------------------------------------------------------+1 row in set (0.00 sec) --按你的写法这么写..mysql> select dayofmonth(date_add(date_add('1000-01-01',interval timestampdiff(month,'1000-01-01',now())+1 month), interval -1 day)); mysql> SELECT day(LAST_DAY('2004-02-05'));+-----------------------------+| day(LAST_DAY('2004-02-05')) |+-----------------------------+| 29 |+-----------------------------+1 row in set (0.00 sec)mysql> SELECT day(LAST_DAY('2003-02-05'));+-----------------------------+| day(LAST_DAY('2003-02-05')) |+-----------------------------+| 28 |+-----------------------------+1 row in set (0.00 sec)mysql> SELECT day(LAST_DAY('2010-08-05'));+-----------------------------+| day(LAST_DAY('2010-08-05')) |+-----------------------------+| 31 |+-----------------------------+1 row in set (0.00 sec)mysql> mysql> SELECT day(LAST_DAY(now()));+----------------------+| day(LAST_DAY(now())) |+----------------------+| 31 |+----------------------+1 row in set (0.00 sec)mysql> 那不一样么 只要把你的时间补全比如2010年9月改成 concat('2010-09','-01')然后使用 如何用命令查询MySQL有多少个日志文件? 2台web服务器配置双机集群负载不均衡 大家来看看这个查询怎么写? 征集mysql源代码修改参与者 RedHat AS 5 上链接mysql出现问题 关于exists和join的问题 求一条SQL 在那里设置MYSQL可使用的最大内存,我的MYSQL闲着内在不用去用虚拟内存 group by一列数据,但是要合并数据,有个函数忘记了,谢谢帮助 请教ERROR:‘WinMySQLadmin.Ink’指向的驱动器或网络连接不可用 mysql正则表达式查询求助 大家帮忙看看这个SQL查询怎么写
mysql> select day(date_add(date_add(concat(date_format(now(),'%Y-%m'),'-01') ,interval 1 month),interval -1 day));
+-----------------------------------------------------------------------------------------------------+
| day(date_add(date_add(concat(date_format(now(),'%Y-%m'),'-01') ,interval 1 month),interval -1 day)) |
+-----------------------------------------------------------------------------------------------------+
| 31 |
+-----------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> SELECT day(LAST_DAY('2004-02-05'));
+-----------------------------+
| day(LAST_DAY('2004-02-05')) |
+-----------------------------+
| 29 |
+-----------------------------+
1 row in set (0.00 sec)mysql> SELECT day(LAST_DAY('2003-02-05'));
+-----------------------------+
| day(LAST_DAY('2003-02-05')) |
+-----------------------------+
| 28 |
+-----------------------------+
1 row in set (0.00 sec)mysql> SELECT day(LAST_DAY('2010-08-05'));
+-----------------------------+
| day(LAST_DAY('2010-08-05')) |
+-----------------------------+
| 31 |
+-----------------------------+
1 row in set (0.00 sec)mysql>
mysql> SELECT day(LAST_DAY(now()));
+----------------------+
| day(LAST_DAY(now())) |
+----------------------+
| 31 |
+----------------------+
1 row in set (0.00 sec)mysql>
只要把你的时间补全比如2010年9月
改成 concat('2010-09','-01')然后使用