作者查詢 / musie
作者 musie 在 PTT [ Database ] 看板的留言(推文), 共22則
限定看板:Database
看板排序:
全部ASHS-94sin448Soft_Job262Web_Design243Ajax175Stock163StarCraft100Gossiping77Tech_Job74NTUMEB94-HW62CGI-Game58bass54MEbasketball50Little-Games47studyabroad45WarCraft42Oversea_Job40NTUDormM633EE_DSnP30Browsers28Google27NTURockClub27X-Japan24Database22Olympics_ISG16Ind-travel14java14toberich14Coming_EE13NTU-K412NTUMEB9512PuzzleDragon12SanFrancisco10WorldCup10Salary9EuropeTravel8GRE8TOEFL_iBT7MobileComm6Prob_Solve6WarCraftChat6Baseball5Japan_Travel5joke5NBA5NtuDormM15Team-NTU5b964060XX4CodeJob4Lakers4Old-Games4share4VISA4Military3NFL3NTU3NTU-K33PostRock3STREET_BALL3StudyGroup3Tennis3yangboy3ASHS-93-li2Disabled2gymnastics2home-sale2HOT_Game2IELTS2KS95-3182mud2NTHU-MSE102Physics2StockPicket2SuperStarAve2Android1Anti-ramp1Audiophile1B981010XX1b982040XX1BROADWAY1Canned1CATCH1CCJH12th3111Chen_C_H1cksh83rd3141CS94Lien1CSMU-D-War31DIP_BASKET1Faith1FJU_Chiayun1FLAT_CLUB1Gulong1Hate1Health_Life1HSNU_10851HSNU_9761Hunter1Immigration1JD_Lover1Kaohsiung1KS92-3121KS93-3201KS94-3091KS94-3201LArc-en-Ciel1Live1Math1Mind1movie1NCCU_SEED1NIUECE911novel1NTU-dreamer1NTU-Guitar1NTUIE971NTUMEB011NTUMT-971NTUST-DT92-11SCU_Chin96C1Spurs1SY_MusicSE1TFSHS64th3181Tou-Liu923141Viator89Chi1WomenTalk1<< 收起看板(124)
3F→:有錢去買powerdesigner03/13 15:10
1F推:把要去掉的相同欄位(客戶編號和信用卡號) GROUP BY 起來.07/12 10:49
2F推:改成用 on user_list.uid = album_list.uid06/19 19:03
5F推:先把if判斷式拿掉試試看, s.uid和r.uid沒交代 ..06/11 16:24
6F→:再把WHERE s.uid = 固定值看看..06/11 16:25
1F推:至少列一下table欄位..04/09 17:40
1F推:假如很常要增刪資料,那就總不能都去改程式碼吧.03/23 11:51
6F推:已經到億了..SQL效率降低是不可避免的.改用noSQL吧y03/21 13:19
1F推:powerDesinger 不知道是不是你想找的..12/22 23:37
2F推:加個 ' ' 好了...12/22 17:50
1F推:不就如同他說的,欄位資料格式不同..?12/05 22:14
5F推:只給這樣資訊 誰也不知道你哪邊出錯= =12/07 14:16