作者查詢 / swpoker

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

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

限定看板：Database

看板排序：

全部Gossiping1153HatePolitics820Warfare632java531MAC327Military303StupidClown248iOS196MobileComm195BabyMother164movie123Stock120PokemonGO113Python110BigPeitou92WorldCup87Lifeismoney79historia78car70iPod69joke66cookclub43PokeMon42sex42DC40I-Lan40bicycle36CoC35FuMouDiscuss34Food33Boy-Girl28Militarylife25Storage_Zone25Anti-Cancer21Database20home-sale20LivingGoods20PC_Shopping20WindowsPhone19marvel17Android16Olympics_ISG14DummyHistory12EatToDie12AntiVirus11Wanhua10NBA_Film9NBAEasyChat9Digitalhome8Q_ary8NSwitch7NTUmed917fastfood6Baseball5HK-drama5KS98-3025media-chaos5CrossStrait4e-shopping4FJU-ACCR944MacShop4NCUT-IM4NTHU_STAT944PCCU-CS4PublicServan4Ajax3biker3Free_box3Hate3HLHS_10thU3IA3japanavgirls3Miaoli3NCCU_SEED3Nintendo3scutran_city3Actuary2Anti-ramp2Beauty2Billiard2CCRomance2CodeJob2Disabled2E-appliance2FCU_EE97A2FLAT_CLUB2Football2GetMarry2GossipPicket2graduate2Hiking2Hong_Kong2Instant_Mess2kindness2KMT2LoL2MacDev2MdnCNhistory2nCoV20192NIU-ECE92b2NUU_ER2Option2Ourmovies2PCSH91_3052PublicIssue2SFFamily2SW_Job2TA_AN2TKU_EE_92C2Translate-CS2USC2WoodworkDIY2YOLO2Zhongzheng2Africa1Agriculture1AndyLau1Asia1ASIA-uni1B96305XXX1Battery1C_Chat1CCK1CGSH87th3211CH7th3101ChineseChess1Christianity1CHSH_98_3011CHU_ME92C1ck57th3141ck57th3151CKPoem1cksh81st3091cksh81st3161cksh85th3141CMCKguitar131CMS_97_S3F1CMWang1Coffee1CPU_CP7611CS_TEACHER1CSMU-HSA961CSMU-MIS941CSMU-MT941CTSH963021CultureShock1DC_SALE1dlsh-7th-3031DYU1EAseries1Eclipse1Economics1Ecophilia1Employee1Facebook1FCU_EE97B1FJU-EE-2004B1FJU-STAT95B1FJU_Fashion1FTHS-1581gallantry1GHIBLI1GIEE_BASKET1Gintama1GO1hardware1HCKuo1HCSHch13_3111HK_Comics1HSNU_10661HSNU_10951HSNU_11431HSNU_8971hypermall1ISUEE93A1JOJO1Koei1Korea1KS91-3051KS92-3131KS94-3121KS96-3141KS97-3051KS97-3101KS97-3201KS_PMAC1L_TaiwanPlaz1Ladies_Digi1Lakers1lifeguard1LTK1Marginalman1MartialArts1MCU-LAW1MED_serve1MRT1Mudran1MuscleBeach1Navy1NCCU04_PSYCH1NCCU98_FM1NCCU_TEA1NCCUbike1NCHU_MKT981NCKU_ECO971NCU91Finance1NCU95IE1NCUIM951NCYU_ANS_981NDHU-ENG-MV1NDHU-His971NDMC-D621NDMC-PH231Neihu1NIT1NSYSU_MIS_971NTHU_ChStudy1NTNU-SLM951NTNUHumanism1NTPU-ACCM941NTPU-ECONM941NTPU-NSTAT931NTPU-STAT961NTUEE-MBElab1NTUEE_VAL1NTUEOE-IOL1NTULawHome1NTUnba20051NTUphy981NTUST-DT93-21NTUST-ET-B931NTUWRC1NUU_Talk1NYUST99_FING1Orzhong97cl1OTT1Paradox1Patent1Pharmacy1Physics1PingTung1Pistons1Plant1Poker1politics1PTHS95-3101PushDoll1Road1Road_Running1RSSH92_3051RSSH93_3051share1Show1sky1sp_teacher1specialman1SSSH-13th3111stationery1STU1TaiShan1tcfsh69th3041Tea1tennis_life1textbook1TFG_pds1THUIM-5th1TigerBlue1Tour-Manager1Transport981travel1TTU-AFL1TuTsau1VET_961Viator97Chia1Violation1wearefriends1WuLing46-3171YP91-3051YP94-3121YZU_EE96A1<< 收起看板(280)

首頁

尾頁

Re: [SQL ] 是否避免null值

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

作者: alan3100 - 發表於 2013/06/19 13:32(12年前)

1^F→swpoker:?可是index會有null就有點奇怪了?06/20 10:17

5^F→swpoker:樓上就是我的疑問06/20 13:14

6^F→swpoker:index會容易濫用~然後異動會導致效能~06/20 16:37

7^F→swpoker:以前遇到某專案會有專人在開發時會監督SQL~避免這種問題06/20 16:37

8^F→swpoker:像現在都只能靠拜拜希望自己或有人會注意到06/20 16:38

9^F→swpoker:遇到某專案的架構師告誡pk fk index 不能有null06/20 16:41

10^F→swpoker:然後還會問說你建這個index要幹碼?!!06/20 16:41

11^F→swpoker:阿~當時覺得很討厭~後來才知道這樣才是好阿06/20 16:42

[SQL ] 匯入資料重複PK問題

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

作者: SmallDruid - 發表於 2013/06/06 09:44(12年前)

3^F→swpoker:你這不是矛盾嗎06/06 16:29

[SQL ] 兩個table結合查詢語法問題

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

作者: Whynopeople - 發表於 2013/05/29 13:44(12年前)

3^F→swpoker:不要用in~直接再join05/29 17:40

4^F→swpoker:table2.CUI1 in (select table.cui from table2) -->???05/29 17:42

5^F→swpoker:你的SQL可以整理一下嗎~要是真的話~有點無言05/29 17:42

Re: [SQL ] 語法請教

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

作者: cloudsan - 發表於 2013/03/24 07:10(13年前)

4^F→swpoker:這種語法都跟DB種類不同而不同~所以DB是那套呢03/25 09:12

[SQL ] oracle分組條件統計

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

作者: blackspace98 - 發表於 2013/02/18 22:12(13年前)

29^F推swpoker:select a,sum(ce) from02/19 15:21

30^F→swpoker:(select a,decode(c+e,0,1,0) ce from testdb)02/19 15:21

31^F→swpoker:group by a02/19 15:21

[問題] pk的選取

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

作者: keyman5566 - 發表於 2013/01/20 21:24(13年前)

1^F→swpoker:如果人沒有邏輯去分~電腦也沒那麼厲害會分01/21 12:31

[SQL ] 搜尋引擎同時匯入多筆資料匯出結果？

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

作者: jordanforme - 發表於 2013/01/15 10:33(13年前)

6^F推swpoker:糟糕你搞錯地方了~不是叫資料庫的真就是資料庫01/16 11:31

[SQL ] 執行多句SQL

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

作者: j12080104 - 發表於 2012/12/24 21:10(13年前)

2^F→swpoker:自己找個語言或腳本來寫吧~我本身使用python12/26 15:55

[SQL ] Oracle "In" (變數)的問題

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

作者: sohumi - 發表於 2012/12/14 12:03(13年前)

1^F→swpoker:u因為真的當字串了 XD12/14 14:17

首頁

尾頁