作者查詢 / JYHuang
作者 JYHuang 在 PTT [ Database ] 看板的留言(推文), 共41則
限定看板:Database
看板排序:
全部Baseball1180Tainan873Japandrama638TW_Entertain583Japan_Travel406DSLR372TaiwanDrama353Road_Running320movie296bicycle227Web_Design206CTV197Olympics_ISG195PHP190Hiking141Gossiping131Ajax128Softball93Storage_Zone91Golden-Award89FITNESS80PC_Shopping67ADS60DC55KSU47WomenTalk47Database41MobileComm36sky34Soft_Job32Network30YuiAragaki30creditcard26Metal_kids26ONE_PIECE26LCD24hardware23biker22MingDow21MRT21outdoorgear21soho21Broad_Band19Printer_scan17swim16DC_SALE15DCT15Bank_Service14Boy-Girl14Browsers14MobilePay14Android12EZsoft12Beauty11car11SRW11SuperStarAve11Audiophile10CD-R9HardwareSale9Salary8UniversityTV8Food7Geography7Key_Mou_Pad7MOD7Roy6StupidClown6B_supporters5BeautyBody5CodeJob5Drama5ainori4Badminton4CMWang4Facebook4Faith4Lifeismoney4Lions4Notebook4VideoCard4BLEACH3Cobras3FJU-EE-BALL3NARUTO3nb-shopping3SuperHeroes3Taipei3Tech_Job3TKU-Softball3ask2BabyMother2BlueAngel2C_Chat2CCF2Cheer2CTS2CYCEsoftball2Dragons2Guardians2happy-clan2HatePolitics2Jacky2joke2Linux2NCCU_SEED2teeth_salon2Theater2TokyoGhoul2Whales2A-BAW1ai-photo1ASHS-93-li1backQuarter1BaseballXXXX1CCU_ACCGS981Chunichi1ck57th3291cookclub1CSMU-HSA961CVS1Du-Du1e-coupon1Eagles1EarthScience1EAseries1Eason1EYESHIELD211Fantasy1FCU_EE97A1FinBaseball1FJU-ACC90a1FJU_BASEBALL1Flash1FLAT_CLUB1Gamesale1HCKuo1HelpBuy1home-sale1HotBloodYuan1HSNU_10551HSNU_11341HSNU_11351Hunter1IAM_Aero0071Ironman1Kaohsiung1katncandix21Kids_Sucker1KR_Entertain1NBA1NCCU08_PHILO1NCHU-TIM961NCKU_MEPhC1NDHU-dcSB1NDHU-His1001NSYSU-EO971NTOU-MME-99B1NTUST-ECE1oeo_491OrangeRoad1OrixBuffalo1Ourmovies1PhySoftball1Ptt-Charity1Railway1SFFamily1ShidaMirai1Suckcomic1SYSOP1tabletennis1Teacher1theLittle1Tigers1TKU_EE_92C1TVCard1TWHiddleston1UKN1Windows1WomanShow1Yup99-061<< 收起看板(181)
4F→: 不過這一個table規劃是純粹存放參數用,不會與其它table04/13 23:45
5F→: 做到關聯。這一點覺得還比較沒差04/13 23:45
2F→: 感謝..我看一下MySQL的工具有沒有這功能06/23 09:05
3F→: 今天再看一下,主單33萬筆、子單10萬筆....06/23 09:12
4F→: 感謝,早上又試了一下。外面再包了一層SELECT GROUP06/13 12:43
5F→: 外面也是用max,min來取check in check out的值。06/13 12:44
6F→: 似乎就OK了06/13 12:44
1F推: 感謝,不過好像取group concat出來再用PHP組合會好些?08/05 13:25
3F→: join是指把我上面提到的sql和產品的sql做join吧?08/05 16:18
4F→: 其實在思考的是,有沒有用count和having以外的方式可以08/05 16:19
5F→: 做條件相符的比對,前面有人提到用SET,不過有點受限08/05 16:19
6F→: 於現有的架構已經上線,不好做修改。08/05 16:20
7F→: 像group_contact似乎也是個不錯的的方法08/05 16:21
5F→: 目前是OK的,只是還是有讓人人不放心08/05 11:51
1F推: 謝謝~06/03 21:59
2F→: 不好意思沒說清楚,不過這個CASE裡兩個Table都是多筆06/03 21:59
3F→: 資料的集合,所以這樣JOIN的話似乎會限縮Table2的範圍06/03 22:00
4F→: 只能取到前幾筆06/03 22:00
1F推: 謝謝~06/03 21:59
2F→: 不好意思沒說清楚,不過這個CASE裡兩個Table都是多筆06/03 21:59
3F→: 資料的集合,所以這樣JOIN的話似乎會限縮Table2的範圍06/03 22:00
4F→: 只能取到前幾筆06/03 22:00
1F→:補充 DBMS是 informix05/22 16:20
3F→:呼..還好MySQL有Group_concat這個函式可以算MD5~04/26 10:12