iteye_18352的博客

-- 添加字段 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...

SELECT COUNT(*) FROM T_User t WHERE t.lastUpdateTime < '2012-11-12';SELECT COUNT(*), DATE_FORMAT(t1.modify_date, '%Y-%m') AS my_monthFROM T71_ROOM t1 WHERE item_number ='200807294787132966' G...