![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
iteye_18352
这个作者很懒,什么都没留下…
展开
-
11sql
-- 添加字段 alter table hist_trans add (sett_batch_no nvarchar2(50));alter table hist_trans add (check_time date) ; alter table hist_trans add (refund_status integer default 0) ;alter table hist_trans add...原创 2012-07-16 17:25:32 · 80 阅读 · 0 评论 -
mysql 统计
SELECT COUNT(*) FROM T_User t WHERE t.lastUpdateTime < '2012-11-12'; SELECT COUNT(*), DATE_FORMAT(t1.modify_date, '%Y-%m') AS my_month FROM T71_ROOM t1 WHERE item_number ='200807294787132966' G...原创 2012-11-15 16:20:25 · 116 阅读 · 0 评论