作者查詢 / LPH66
作者 LPH66 在 PTT [ Database ] 看板的留言(推文), 共96則
限定看板:Database
看板排序:
全部Math8895C_and_CPP6694Minecraft2011puzzle1798Little-Games1256PHP992Web_Design736killercorp717java657SYSOP599Programming587Mathematica451Windows394IME389Prob_Solve389Ajax321RegExp298b94902xxx229PttBug229HOT_Game210Visual_Basic207Inference204Hunter198Steam168NTU-K9167KS94-317160EzHotKey138BoardGame131Conan122HarryPotter120CSSE116Flash104Database96GameDesign94AndroidDev91Android90Kindaichi_Q88Wikipedia74LaTeX71BBSmovie59SMSlife57DeathNote54riddle52Weyslii49wretch42IMO_Taiwan38Suckcomic38b96902HW37NTU37b94902HW35Doraemon30NTU-MAGIC26NTUDormM723NTUcourse21ONE_PIECE19b95902xxx18KSHS_Talk18b95902HW15NTNU_Lin_9615PLT15C_Chat14CSCouncil11PttCurrent11transgender9Translate-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)
2F推: 資料庫存時間基本上是 Unix timestamp, 這東西不管閏秒12/30 20:21
3F→: 或者應該說這種要處理的都不是在資料上處理12/30 20:22
4F→: 而是在軟體程式面上做一些調整12/30 20:22
5F→: 那除非你的操作即時性很高 (如你提的防火牆) 否則不用擔心12/30 20:26
6F→: 話說回來, 上次閏秒也才去年中的事, 應該多少有點經驗吧?12/30 20:27
1F推: 呃, 有差嗎? 就把你原來寫 192.168.0.* 的地方改成這就行啦11/15 02:53
2F→: 你都從 localhost 改成 192.168.0.* 過一次, 同樣方法而已11/15 02:53
3F推: 水晶球猜: 原 PO 需要的是 AND 或 OR 關鍵字11/15 13:45
1F推: 你可以查 join 怎麼用09/05 16:58
2F推: 這種八成都是 SQL 有錯所以 $result 變成 false 了10/29 00:18
3F→: 去 phpmyadmin 裡試試看你的 SQL 對不對10/29 00:19
5F推:回 1F 推文, 應該說是用 ; 來表示一行指令結束03/24 17:32
6F→:如果沒有 ; 則就一路串到結束這樣03/24 17:32
1F推:你還要加上索引的空間...01/01 13:09
7F→:系統暫時下線一會兒應該就不怕沒釋放的 lock 了吧 @@09/06 10:56
1F推:你的 E 的儲存型態是文字吧?06/20 16:52
2F→:呃, 我是說 L 不過應該兩個都是 XD06/20 16:52
3F→:你應該要用 REAL 型態存 這才是浮點數06/20 16:53
3F推:那又怎麼會有 where phone is null 的 query...06/20 13:08
4F→:或者該問為什麼會在被索引的欄位裡放 null06/20 13:09