作者查詢 / LPH66
作者 LPH66 在 PTT [ Database ] 看板的留言(推文), 共96則
限定看板:Database
看板排序:
全部Math8745C_and_CPP6646Minecraft1902puzzle1782Little-Games1256PHP992Web_Design735killercorp717java657SYSOP599Programming582Mathematica451Prob_Solve389Windows387IME381Ajax319RegExp297b94902xxx229PttBug229HOT_Game210Visual_Basic206Inference204Hunter198NTU-K9167KS94-317160Steam156EzHotKey138BoardGame131Conan122HarryPotter120CSSE115Flash104Database96AndroidDev91GameDesign88Kindaichi_Q88Android87Wikipedia74LaTeX71BBSmovie59SMSlife57DeathNote54riddle52Weyslii49wretch42IMO_Taiwan38Suckcomic38b96902HW37NTU37b94902HW35Doraemon30NTU-MAGIC26NTUDormM723NTUcourse21ONE_PIECE19b95902xxx18KSHS_Talk18b95902HW15NTNU_Lin_9615PLT15CSCouncil11PttCurrent11C_Chat10transgender9Translate-CS9VR9NTUDormG18Education7HSNU_10857KS93-3207NCKU-BEH957NDMC-D627PttNewhand7b99902HW6hikarugo6NtuDormM16youtuber6b96902xxx5b97902HW5CompilerDev5GO5L_LifeInfo5MJ5NSwitch5SummerCourse5tutor5Hsinchu4Liu4PushDoll4AppsForBBS3b98902HW3CSIE_WSLAB3Gossiping3Kao-KSHS3KS93-3163NARUTO3NTUST-DT93-23RSSH94_3013b97902xxx2ck50th3232ck55th3252ck58th3122CS_Badminton2CSIE_Mahjong2NANLIN3012NDHU-His962NTUDormFJr2NTUGIEE_EDA2PCman2PCSH91_3052PttSuggest2PttWeb2SFFamily2WinMine2Abin1AGO1Aquarius1Army-Sir1ASHS-93-li1AskaYang1B92310XXX1b99902xxx1blind_pc1Browsers1CCSH_92_3161CGU-MED-991CGU_EE981ck55th1201ck55th3241ck56th3181CK84Courage1CLHS-53-131CM38th071consumer1CPU_AM7011CPU_FC7311CSMU-MED941CTSH913021CTSH923051DaZhi6thH3021Eclipse1FJU-AM-901FJU-BA92C1FJU_GF1FSHS-94-3181Google1Grad-ProbAsk1Greenfield1HKday1Hoobastank1HORTUS-911HSNU_10731HSNU_9291HSNU_9381HSNU_9581HSNU_9851HSNU_9891HSNU_9901Hu_Yen_20041HY-40-Xin1ILSH-943131INSECT-901Itchie1Jay1JH30th3061Jinmen1joke1kekkai1KhalilFong1KS90-3091KS94-3151KS94-3211KS98-3021lab6211LD_IM93-21MATLAB1MDscience6th1Moto_GP1MuscleBeach1NCCU00_Stat1NCCU02_PSYCH1NCCU03_ETHNO1NCCU03_PF1NCCU04_MAT1NCCU04_Stat1NCCU98_RMI1NCCU99_Stat1NCHU-AGR001NCHU-AGR071NCKU-PH981NCUFingrad031Network1NIUECE911NTNU_bridge1NTOU-YP1NTPU-JLAW941NTPU_CK_CM1NTU-GIIB20021NTU-GIIB20041NTU95thLIS1NTUBIME-1021NTUCH-941NTUDormM61NTUE-Art961NTUE-CS1031NTUE_Nse961NTUE_Nse981NTUHistory881NTUHorti961NTUKGA1NTUMath911NTUMath941NTUMT-921NTUMystery1NTUNewPlace1NTUST-DT92-11NTUT_EE490A1NUTN_SSSS1Oguri_Shun1Old-Games1onlychild1Peitou29t3161Penny1PERCUSSION1PokeMon1PttHistory1Romances1RSSH93_3071SCU_ACCM971SM02th031SM05th3xx1SOFTSTAR1SSSH-13th3111STDM-87-3051Stephen1streetsinger1TFGCRC1THU-P-Softbo1TigerBlue1TMU9711Translation1TSH97_YK1Ur-hsing1VET_921w-inds1wegoJT3021WuLing46-3051WuLing46-3171YP91-3121YP92-3011YP92-3031YP94-3141<< 收起看板(252)
3F推:Hint: 你可以從第 k 筆開始顯示11/22 22:12
2F推:這種事情我會建議在進sql前處理好 這樣錯誤狀況也方便判斷09/18 15:08
1F推:INTERVAL 是 MySQL 的關鍵字 所以如果是欄位名請加 ``07/17 23:51
2F→:我會建議養成欄位名加 `` 的習慣就是了07/17 23:52
1F推:having 改成 where 放在 group by 前面這樣試試?03/07 16:45
2F→:先用 where 篩過再 group by 起來應該就是你要的了...03/07 16:46
1F推:你從哪裡找到 mysqli_array 這個函式的?01/28 12:05
1F→:最簡單的做法是 auto_increment 欄位 還是你想要怎樣?12/24 18:12
1F推:說起來其實PK(甚至是index key)做的就是這個對照表07/03 04:20
2F推:而且它會用些技巧讓存取少量資料時不致於要掃整張表07/03 04:24
3F推:不過大量資料時的慢也正是相對用ROWID多了這個查表的動作07/03 04:29
4F推:所以如果資料變動率不高但查詢的量非常多的話不妨一試07/03 04:34
1F推:... sort by `編號` desc limit 1; 如何?03/20 13:53
3F推:那是 5C...另外這字是 UAO 放在 big5 的造字區的12/25 01:13
4F推:和 UAO 的日文問題是同一件事...12/25 01:18
2F→:其實 locate 是從這裡翻到的: http://tinyurl.com/7e7ve12/12 13:16