作者查詢 / knives

總覽項目：發文 | 留言 | 暱稱

作者 knives 在 PTT [ Database ] 看板的留言(推文), 共16則

限定看板：Database

看板排序：

全部Gossiping47390PuzzleDragon12284Stock10635C_Chat4803HatePolitics3202home-sale2517Option2145ONE_PIECE2039P2PSoftWare1130TaiwanDrama974Soft_Job821Palmar_Drama738Baseball709Browsers696Broad_Band598PHP391SRW378movie333TORIKO319Web_Design312PSP-PSV232NARUTO208TaichungBun208japanavgirls200AC_In189iOS173NSwitch170EZsoft159Salary159PlayStation150Hunter133HitmanReborn128MobileComm127CMWang126Free_box126Ajax112LCD110Storage_Zone102Tech_Job100WorldCup92MAC82AudioPlayer76Conan68Sangokumusou63AVEncode61H-GAME61KoreaDrama58Network50CFP48MLB47Teacher47SET42Windows41BioHazard40EYESHIELD2139BBSmovie37Japandrama37joke37rent-exp28Haruhi27ask26YUGIOH25FTV23InitialD22FinalFantasy21NY-Yankees21CD-R17KERORO17Database16HCKuo16L_LifeInfo16Golf15Google15Key_Mou_Pad15Liu15AfterPhD14Akimine14Gamesale14Militarylife14L_TalkandCha13PublicIssue13Bank_Service12Employee12PublicServan12SENIORHIGH12car10consumer10creditcard10CTV10hardware10Hate10hypermall10Marginalman10ShamanKing10WomenTalk10CVS9Examination9Gov_owned9GUNDAM9Instant_Mess9java9SchoolRumble9TTV9ANIMAX8StockPicket8Flash7Linux7RedSox7Tainan7Taoyuan7ARIA6DeathNote6Finance6GossipPicket6IA6LittleNew6MOD_AP6PCSH91_3056PingTung6PttLifeLaw6studyteacher6TPC_Police6TWvoice6Broker5Chiayi5Expansion075facelift5fastfood5Gash5Kaohsiung5LAW5PeopleSeries5Suckcomic5About_Life4CareerPlan4cksh80th3074Digitalhome4GetMarry4Keelung4KS92-3244Lottery4media-chaos4nCoV20194NTUE-ME954pay_home4PC_Shopping4politics4Sub_GMobile4Azumanga3Braves3Clarify3e-coupon3FJU_GF3Geography3Hu_Yen_20043Jeremy_Lin3Kindaichi_Q3MacShop3NTU3ORTalk3Steam3SYSOP3tax3weiyin3WorkinChina3WorldCupGG3Yakitate3Android2BAHAMUT2BCC_PCC2biker2Blue_Jays2CCJH-89g-3142CCJH-89g-3152China-Drama2cjjhs3272ck50th3232ck55th3022ck56th3062CKCMGuitar142cksh81st3202CM39th142CTS2dsps-6yi2FamilyCircle2ForeignEX2G-S-WARRIORS2HsinTien2HSNU_10082KGSH92-3012KS93-3162L_TaiwanPlaz2Law-Service2lifeguard2medache2money2MuscleBeach2NCCU03_DIP2NCTU_TALK2NIUECE912NTHU_FC2NTU-EM932NTUST-DT92-12Olympics_ISG2OTT2PhD2Powerful_PRO2Programming2PttNewhand2sex2Shu-Lin2ShuangHe2SongShan2specialman2SSSH-11th3132TFG02Unity2ThuPSBK2TigerBlue2TKU_EW94B2ToS2Trace2TTU-I90B2TTU-I91A2TVCard2TY_Research2VideoCard2Violation2Vision2XBOX2YP91-3072YP91-3082AC_Music1Adachi1AI_Art1AndroidDev1AntiVirus1ASHS-93-li1AskBoard1BigBanciao1Blog1Boy-Girl1Buzz_Suggest1C_ChatBM1CCSH_91_3201CEM921CFantasy1chess1Chulin-Chung1ChungLi1ck50th3291ck55th1201ck55th3241ck56th3041ck56th3181ck56th3211cksh80th3161cksh80th3231cksh80th3241CODE_GEASS1Comic1CSMU-MIS941CTSH913021CTSH923011CyberFormula1CYCUEL95A1CYSH97Y3181DIABLO1dog1DragonBall1DragonNest1Eclipse1Economics1Editor1Electronics1equal_change1FJU-ACC90a1FJU-CH-2003A1FJU_AD-041FJUBAsoftbal1Food_Safety1Football1Foreign_Inv1FTP1FuMouDiscuss1Ghost-Shell1GuessX31Hayate1HCHS923161HisSoccer1HsinChuang1HSNU_10851HSNU_9381HSNU_9461HSNU_9631HSNU_9891HSNU_9901HSNU_j1021HTSH-7th3131I-Lan1ID_Multi1Interdiscip1Jae-Won1kartrider1KenAkamatsu1KOTDFansClub1KS91-3051KS93-3221KS94-3151KS95-3141KS97-3151KUAS_MBA941Kusan_89-3121LeBronJames1License1Lifeismoney1Little-Games1LoL1LoveLive_Sip1MDscience6th1Mechanical1MiHoYo1Military1MingDao33H21minoru1MobilePicket1NaS-02-021NBA1NCCU01_ETHNO1NCCU03_BANK1NCCU03_ETHNO1NCCU03_PF1NCCU04_Eco1NCCU04_Histo1NCCU_TEA1NCHU-AGR001NCHU-AGR031NCHU-PP871NCU_HSNL1NCYU_Fst_981NDHU-lf961NDHU-phy971NDMC-D621NDMC-F81NDMC-M1031NDMC-M1041NDS1Neihu1NHCUE-95ee-21Nintendo1NIUEE93a1novel1NTCYSG1ntnuepc911NTPU-COECO911NTUCE-1011NTUChallenge1NTUMT-921Nurarihyon1Office1Orioles1OSSTUDENT861Patent1PathofExile1PCSH91-3041Post1Property_M1PSY1PttCurrent1PublicBike1Python1RegExp1Rent_apart1Road1RSSH92_3051RSSH94_3011Sassy-babe1seiyuu1Shana1ShoheiOhtani1Sijhih1Singapore1SJU1SlamDunk1SM05th3xx1StarCraft1streetfight1StupidClown1STUST1SuperBike1SuperHeroes1SuperIdol1Taitung1TamShui1TAXI1TFG03Winner1TKU_Software1toberich1Tokusatsu1Transport921TunHua05t3111twin1Ur-hsing1VET_921YP92-3011YP92-3031YP92-3101YZU_CN99A1<< 收起看板(407)

首頁

尾頁

Re: [SQL ] 執行Insert語法，出現 metadata lock

[ Database ]2 留言, 推噓總分: 0

作者: DarkKiller - 發表於 2019/05/30 16:13(6年前)

1^F→knives: 好的，下次出現，我再用這個查，因為我只知道要show proc05/30 16:51

2^F→knives: ess05/30 16:51

Re: NoQL的update問題

[ Database ]1 留言, 推噓總分: +1

作者: carlcarl - 發表於 2013/03/01 02:19(13年前)

1^F推knives:感謝回答03/04 09:51

[SQL ] 可以這樣寫嗎

[ Database ]2 留言, 推噓總分: 0

作者: knives - 發表於 2013/02/01 11:44(13年前)

2^F→knives:感謝分享02/04 07:02

[SQL ] Trigger可以這樣做

[ Database ]7 留言, 推噓總分: +3

作者: knives - 發表於 2012/06/11 15:46(13年前)

2^F→knives:是這樣嗎06/11 15:57

4^F→knives:還是不行阿06/11 16:05

[系統] 想請問這樣的功能怎樣才能達成呢?

[ Database ]8 留言, 推噓總分: +2

作者: gmpalex - 發表於 2011/11/14 22:05(14年前)

4^F→knives:你就把條碼機想像成是鍵盤的輸入裝置不就得了，沒有那麼難11/15 09:42

[SQL ] 有辦法將這兩段SQL合併一起做嗎

[ Database ]7 留言, 推噓總分: +2

作者: knives - 發表於 2011/11/11 14:37(14年前)

4^F→knives:如果我pic沒有count這個欄位11/11 14:50

5^F→knives:我想我知道該怎麼寫了11/11 14:57

7^F→knives:是的，不過我想更強求的是能不能用aid in() 一次改多筆11/11 16:26

Re: [SQL ] 怎麼找出大於某數的資料

[ Database ]1 留言, 推噓總分: 0

作者: danielguo - 發表於 2011/06/09 06:06(14年前)

1^F→knives:原來如此，感恩06/10 08:28

Re: [SQL ] 這樣的要求可以用一個SQL來解決嗎

[ Database ]3 留言, 推噓總分: 0

作者: lazyhome - 發表於 2011/04/18 16:14(14年前)

1^F→knives:感謝了，另外有沒有辦法讓NULL自動傳回0阿04/18 16:40

3^F→knives:謝謝回答，已解決了04/18 17:33

[SQL ] 要找出個別月數的統計

[ Database ]3 留言, 推噓總分: 0

作者: knives - 發表於 2010/07/09 11:28(15年前)

2^F→knives:樓上，我試試07/09 11:44

3^F→knives:樓上，我是另外用year(FROM_UNIXTIME(dateline))，有沒有07/09 11:54

[SQL ] 請問這樣的執行時間是正常的嗎

[ Database ]7 留言, 推噓總分: +1

作者: knives - 發表於 2010/05/12 11:46(15年前)

5^F→knives:可是card_id已經是惟一的主鍵了，還有必要加index嗎05/13 09:30

首頁

尾頁