作者查詢 / grence
作者 grence 在 PTT [ Database ] 看板的留言(推文), 共182則
限定看板:Database
看板排序:
全部CCK-FREE367Ajax292Web_Design253Database182AOE93CCK-GENERAL83CCK-CHUHEN82Soft_Job62CCK44chess42ChineseChess41chatskill25Chess_Castle16Shouchun15Lujiang12bicycle9DIABLO9PushDoll9Hanzhong8CodeJob7travian7C_Sharp6StupidClown5joke4Changan3Xiangyang3CATCH2IME2NDHU-PCSH2Prob_Solve2RegExp2ASIA-uni1CareerLady1ChessService1CHITEE4UD90A1cksh81st3101FJU-ACC91a1FXM91-3291G-baseball1ginfa1Jiangling1NCCU_CHESS1Ncku_Chess1NCNUEM1NDMC-PH241NTHU_STAT941NTUBIME-1011NUU_CSIE1PhotoCritic1soho1TFG98Chung1TTSH-11th3021wisdom1<< 收起看板(53)
3F推:通常是都要,只是因為 where只篩一間公司05/02 19:39
1F推:group by a1.angle_no, b1.angle_name04/09 20:14
1F推:like..雖然有效能上的問題,資料少是可以的04/05 00:43
2F推:table3=table2+table1.部門,子查詢就搞定?03/22 01:45
2F推:寫不好還有url?sql=ooxx後端直接丟進DB的咧XD03/16 23:35
3F推:但是要裝office..orz03/13 00:41
1F推:join只用一個跟用三個比當然快,但實際狀況我看不太懂02/16 16:14
1F推:哪些算假日? 國內國外假日又不一樣,只能人工判斷(規則)吧02/09 22:09
2F推:考慮資料變動頻繁與否、預計資料筆數多寡、程式架構..ect01/18 15:22
3F推:打錯字 orz01/18 15:32
1F→:SELECT 出來再 INSERT 然後DELETE..感覺在惡搞XD01/26 16:56