作者查詢 / terrybob
作者 terrybob 在 PTT [ Database ] 看板的留言(推文), 共29則
限定看板:Database
看板排序:
全部Hunter495Gossiping325SchoolRumble298Web_Design276NARUTO248PHP197JP_Entertain177Salary164KR_Entertain159DeathNote139Soft_Job96ONE_PIECE86Old-Games80Hate73sex73PeopleSeries67Suckcomic66WOW64AndroidDev52Ajax45BigSanchung35JOJO31Android29Database29Facebook23HatePolitics22ComeHere19GTA18ObataTakeshi17Steam17java16The-fighting16Google15SUZUKA14Koei12Mabinogi11Baki10Palmar_Drama10KINGDOM9Ocean9StupidClown9kochikame8CS_TEACHER6joke6NUU_Talk6TLDS6Visual_Basic6MrFullswing5TigerBlue5UniversityTV5ArakawaCow4BBSmovie4BERSERK4CodeJob4KenAkamatsu4Printer_scan4PttNewhand4C_Sharp3H-GAME3HatePicket3IU3PC_Shopping3PushDoll3CareerLady2Daan2DirectSales2FJU-ACC90a2FongShan2Hiking2HK-movie2Hokuto2HRM2HSNU_10082HY-40-Xin2ILSH-953082Kawashita2Office2specialman2TFSHS67th3092WarringState2YUYUHAKUSHO2AfterPhD1AllTogether1Anti-ramp1Blog1CD-R1CFantasy1Chan_Mou1Christina1CHU_ME92C1cjjhs3271ck50th3231ck56th3221ck56th3301ck57th3081ck57th3151CSMU-HSA951CSMU-MIS941CSMU-MT941CSonline1CYCUEL95A1Digital_Art1Doctor-Info1Employee1Emulator1FCU-INS93B1FCU-PF20061feminine_sex1FinalFantasy1FJU-EE-2005A1FJU-Leader1FLAT_CLUB1Free_box1gift1Gintama1GlassNoKamen1HarryPotter1HCSHch13_3111Health1Health_Life1HK_Comics1home-sale1hotspring1HsinChuang1HSNU_10651HSNU_10981HSNU_11151Instant_Mess1kartrider1Keelung1kenichi1KenShin1KingdomHuang1kodomo1KS92-3131KS93-3201KS94-3121L_SecretGard1Lab7201Language1Lineage1LoveGame1MapleStory1MartialArts1mathsoftball1Minecraft1MOD1Mudran1NANLIN3011NCCU_SEED1NCUECON961Network1NH11th3053091NKHS-94-H3C1NTHU-EE-CAPT1NTNU_EPA_951NTNUCH93C1NTPU-CRIM931NTU-Karate1NTUE-DC1031NTUSTMIS_M941o-p-children1Odoko-juku1P2PSoftWare1paranormal1PingTung1politics1PublicServan1PuzzleDragon1RegExp1RockMetal1RSSH91_3011San-Ying1SCU_ACC_96A1SCU_CIS-92A1Sijhih1SLG1SNSD1soul1SouthPark1Stephen1SuperJunior1SYSOP1tennisprince1TFSHS65th3061TFSHS65th3201TKU_EE_92C1TKU_EW94B1TSH93_11TTU-AMath1Wanted1Wikipedia1Windows1WindowsPhone1Wrestle1YCSH_alumni1ZEA1<< 收起看板(197)
2F→: 我的話,工作表、資料表1對1,然後產index去設定欄位03/24 16:56
3F→: 60萬筆很少啦…每個資料表要有互相對應的欄位,去對應03/24 16:57
4F→: 這樣未來維護、跟提昇速度…等,才會比較好。03/24 16:57
5F→: 先建資料表吧…建完再看結構、欄位、sql是否要調整?03/28 12:31
6F→: 沒有所謂多久內執行完算正常的,比之前更快才是目的03/28 12:31
1F→: 你可以列出理想結果比較快,有時會看不太懂11/19 17:45
1F→: 開ms-dos,登入mysql並匯出…?08/19 13:33
5F推: 租用的話,就要看os再決定了…(汗)08/21 13:26
2F推: 該資料表需要新增擁有主要索引的欄位08/19 09:55
1F→: 索引、sql寫法……還有滿多方面可以考量的…06/04 14:46
2F→: 用程式解決吧11/26 13:47
1F推:謝謝大家的幫助。07/09 10:34
6F→:謝謝幫助07/09 10:34
1F→:要看有沒有語系跟特定功能綁在一起 不然1個table就可以了02/24 16:17
9F→:謝謝kolynn,我是用mysql,你還是有幫助我解決問題了11/15 00:19