数据库操作
small white rat
Good Code is a love letter to the next devoloper who will maintain it.
展开
-
mysql查询问题
select news0_.id as id0_, news0_.cdate as cdate0_, news0_.clicks as clicks0_, news0_.content as content0_, news0_.editor as editor0_, news0_.htmlP原创 2012-03-11 23:51:03 · 361 阅读 · 0 评论 -
MySQL日期时间函数大全
DAYOFWEEK(date) 返回日期date是星期几(1=星期天,2=星期一,……7=星期六,ODBC标准)mysql> select DAYOFWEEK('1998-02-03'); -> 3 WEEKDAY(date) 返回日期date是星期几(0=星期一,1=星期二,……6= 星期天)。 mysql> select WEEKDAY('1997-10-04转载 2012-03-11 22:48:24 · 281 阅读 · 0 评论