作者查詢 / billy522
作者 billy522 在 PTT [ Database ] 看板的留言(推文), 共24則
限定看板:Database
看板排序:
全部BigShiLin113CHU_CS92B43ONE_PIECE40Road_Running29NARUTO27FTV25Android24Database24Golden-Award23Lakers23bicycle19CTS16ToS16Broad_Band12StupidClown11DSLR9PC_Shopping9sex8joke7Stock7feminine_sex6NBA6Lifeismoney5watch5CATCH4ChainChron4Mancare4Storage_Zone4Insurance3LivingGoods3MobileComm3Army-Sir2Baseball2Boy-Girl2BuyTogether2CS_Softball2Facebook2FLAT_CLUB2Gossiping2movie2MuscleBeach2NY-Yankees2PttCard2TTSH-12th3172About_Life1AOE1BA_baseball1BabyMother1Bank_Service1bicycle-tour1biker1CHSH_GTC1CoC1Cross_Life1CSMU-D-SC1CSMU-HSA961CTSH963011CYCU_ICE90AB1CYCU_MIS_93A1CYSH97Y3181Datong1Digitalhome1Drama-Ticket1drawing1E-appliance1EuropeTravel1Examination1FCU-MSE-931FCU-MSE-971FCU_EE97A1FJ_Astroclub1FJU-Family1Garena1Gemini1hjsh1ILSH-963081ILSH-983091Instant_Mess1kachaball1KS97-3081KS97-3101KUAS1MayDay1media-chaos1MP1NCU_MATH861NEHS19th41NKFUST1NTHU_KAVALAN1NTOU_HRE_93b1NTU-DMCC1NTUastclub1NTUST-ENG1NTUST-HC-971NUTN_SSSS1Scorpio1SCU_Talk1STDM-94-3151STUST1TaiShan1TaiwanDrama1Taoism1TFSHS68th3211Theater1TTU-talk1TVCard1TW_Entertain1WarCraft1Web_Design1WorldCup1XBOX1<< 收起看板(111)
1F推: 依照日期(logTime)BY天去切,logTime要加在PK中01/06 19:52
2F→: 第一次切表先定義好,之後寫SP每日執行切表排程01/06 19:53
1F→: case when pb.source_id is null than pb.related_id04/01 08:31
2F→: else pb.source_id end04/01 08:31
2F推: 或是 and coalesce(date,'') != ''01/12 07:36
4F推: 推分享06/05 08:05
1F→: 用substring把date+time組成2017-02-01 01:01:01格式試?02/11 12:06
4F→: http://sqlfiddle.com/#!15/0cab0/3/002/11 15:05
6F→: 直接轉型就是時間http://sqlfiddle.com/#!15/0cab0/2/002/11 17:41
1F→: JOIN 表C ON 表A.Cid = 表C.Cid and 表A.Bid = 表C.Bid02/08 20:42
1F→: 你left join() 中間的SQL好像就是答案?05/29 14:10
1F→: trigger?05/21 23:04
1F→: insert into tableA (...) select 1,'A',max(seq)+102/05 16:04
2F→: from tableA 不知道是不是符合你要的02/05 16:05
1F→: update table set N2 = 空白 where N2 in (01/14 00:36
2F→: select N2 from table group by N2 having count(*) >1)01/14 00:36